Text gets truncated and garbled in memo field

[Guest]

I have a form with one text box. Users copy part of the data from a field on
one form and paste it into this new form's textbox. The data is correct in
the textbox on the new form after pasting. There is a button on the form that
runs an update query that inserts this memo text into a table. However, the
text in the table gets cut off and the last portion of the data is several
garbage characters.

The text that is correct is over 255 characters (between 510 and 525
actually) which makes me think it isn't the known Access bug.

This doesn't happen with text everytime. It appears to only occur with text
over about 500 characters and spaces. I really need this fixed as soon as
possible. What is happening?

 

[John Nurick]

The fact that no on has replied so far means that I'm not the only one
who doesn't know what's going on here.

If the data is in a Jet (mdb) file, one suspicion is that the database
is corrupt. Here are a couple of good places for information:
http://www.granite.ab.ca/access/corruptmdbs.htm
http://allenbrowne.com/tips.html#Corrupt

Here are a couple of things to try (working on a copy of the database so
as not to risk making any corruption worse):

-Turn off Unicode compression in both tables.

-Create a new table containing a memo field, and modify the update query
to append the record to the new table.

Does either of these make any difference?