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.
 
You must log in or register to reply here.

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

Similar Threads

memo field is limiting characters 1
Data truncated in text box on form 14
Make Table Query Truncating Memo Field at 255 Characters 2
does FORMAT function cause issues with Memo fields? 3
VBA ADODB Automation - Truncated Memo Fields 3
MEMO Field cut off on Form 3
Memo Field Limits??? 5
Memo fields 3

Back
Top