Text Misbehaving!!!

[Bill]

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

 

[Brendan Reynolds]

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.

 

[Nikos Yannacopoulos]

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

 

[Douglas J Steele]

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

 

[Bill]

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.