memo field format

G

Guest

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

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top