Memo Field Truncating

  • Thread starter Thread starter Freddie Hagenah
  • Start date Start date
F

Freddie Hagenah

I'm working in a database that was created in Access 95
and has been converted to Access 97 and then to 2000. A
memo field in one of my forms truncates data I've entered
after approximately 75 characters. I experienced this
problem before and I know there's an easy fix, I just
can't remember what the fix was. Thanks for your help!
 
If the field allows you to enter only 75 characters, it is a Text field, not
a memo field.

If the field just loses any charcters after the first 75, the database if
corrupt.

If the field displays only the first 255 characters, then:
1. Remove anything in the Format property of the field in table design, or
the Format property of the text box on your form/report.

2. Do not allow your query to perform any aggregation on this field. For
example, remove DISTINCT from the SQL statement, or use First in the Group
By row under the memo field.
 
Back
Top