Welcome to SPN

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

Sign Up Now!

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.
     

Share This Page