sheniece via AccessMonster.com said:
i am tring to assign a memo field to a string but the string is truncating
the value. I thought a string can hold 65k characters.
A string variable can hold 2^31 characters. I believe your problem is a
quirk of the memo field, not the VBA string variable.
Has the field always been a memo type, or has it ever been a text field and
has subsequently been converted to memo?
How many characters is the field being truncated to?
Ed Metcalfe.