Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Text Misbehaving!!!

Discussion in 'Information Technology' started by Bill, Nov 10, 2005.

  1. Bill

    Bill
    Expand Collapse
    Guest

    Hi All,



    To avoid having to retype it I have copied a number of short data entries
    from a Word table straight into Access. I now notice that the text in the
    Access table is behaving strangely, i.e. it overlaps, there is a space
    between the end of the text and the cursor and the text is difficult to
    edit..



    Is there any way that I can fix this without having to retype it all.



    Ta.

    Bill
     
  2. Loading...

    Similar Threads Forum Date
    Malaysia Hindus, Sikhs In Malaysia Appalled With University Textbook Ridiculing Their Faiths Breaking News Jun 14, 2016
    Hard Talk Taking One Liners Out Of Context From Gurbani To Allow Intellectual Independence? Hard Talk Apr 23, 2016
    India Protests in India Over the Desecration of a Holy Text Leave Two Dead Breaking News Oct 16, 2015
    Learn Punjabi Convert Punjabi text Language, Arts & Culture Oct 11, 2013
    Sikh Coalition Harmeet Kaur Took the Lead ! First to Respond to Textbook Challenge ! Sikh Organisations May 25, 2013

  3. Brendan Reynolds

    Brendan Reynolds
    Expand Collapse
    Guest

    To get rid of the extra spaces, you can use the Trim function in an update
    query ...

    UPDATE YourTableName SET YourFieldName = Trim([YourFieldName])

    I'm not sure I understood the description of the other problems - perhaps
    you could try the update query then post back if you're still having other
    problems.

    --
    Brendan Reynolds


    "Bill" <bill@bill.com> wrote in message
    news:uDcnKcd5FHA.3384@TK2MSFTNGP11.phx.gbl...
    > Hi All,
    >
    >
    >
    > To avoid having to retype it I have copied a number of short data entries
    > from a Word table straight into Access. I now notice that the text in the
    > Access table is behaving strangely, i.e. it overlaps, there is a space
    > between the end of the text and the cursor and the text is difficult to
    > edit..
    >
    >
    >
    > Is there any way that I can fix this without having to retype it all.
    >
    >
    >
    > Ta.
    >
    > Bill
    >
    >
     
  4. Nikos Yannacopoulos

    Nikos Yannacopoulos
    Expand Collapse
    Guest

    Bill,

    You have probably copied (invisible) control characters from Word, along
    with the text. Two work-arounds:

    1. Use Notepad as an intermediate; copy from Word, paste in Notepad,
    then copy from Notepad and paste in Access. Notepad doesn't understand
    Word's special characters, so they get lost

    2. Make Word show the special characters before you copy, so you leave
    them out of your copied text; Word's standard toolbar has a button for
    this on the left of the zoom factor drop-down.

    HTH,
    Nikos
     
  5. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    It may well be that there are special unprintable characters that came along
    with the text.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Bill" <bill@bill.com> wrote in message
    news:uDcnKcd5FHA.3384@TK2MSFTNGP11.phx.gbl...
    > Hi All,
    >
    >
    >
    > To avoid having to retype it I have copied a number of short data entries
    > from a Word table straight into Access. I now notice that the text in the
    > Access table is behaving strangely, i.e. it overlaps, there is a space
    > between the end of the text and the cursor and the text is difficult to
    > edit..
    >
    >
    >
    > Is there any way that I can fix this without having to retype it all.
    >
    >
    >
    > Ta.
    >
    > Bill
    >
    >
     
  6. Bill

    Bill
    Expand Collapse
    Guest

    Thanks all.

    The notepad solution worked. In fact i am copying from access into notepad
    and then copying back over the top. Seems to be dong the job!!

    Will watch for this one in future!!

    Thanks again.
    Bill.
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page