memo field format

D

Dcbrown428

I have tried to read through other postings, but haven't found an answer - or
at least not one that's in layman's terms that I can interpret. I need to
change a text field to a memo field. I have gone into the design view of my
table and changed it from text to memo, but I must need to change the format
field or something because I'm still being cut off at 255 characters.

Thanks,
Donna
 
J

John Vinson

I have tried to read through other postings, but haven't found an answer - or
at least not one that's in layman's terms that I can interpret. I need to
change a text field to a memo field. I have gone into the design view of my
table and changed it from text to memo, but I must need to change the format
field or something because I'm still being cut off at 255 characters.

Thanks,
Donna
Click to expand...

You need to be sure that the field does not have *any* Input Mask or
Format property defined; and you cannot index or sort by the field.
Any of these will cause this kind of truncation.

John W. Vinson[MVP]
 
Top