Mysterious Change in Memo Field

  • Thread starter Thread starter NancyD
  • Start date Start date
N

NancyD

I created a database with a memo field for large
comments. Recently it will no longer accept the same
information it had previously. It is exhibiting the
characteristics of a text field instead, although it is
still a memo field. This was an Access 97 database which
was upgraded to XP. But it had been operarting fine under
the XP version until about three weeks ago.

The data is being entered through a form into a text box.
 
NancyD said:
I created a database with a memo field for large
comments. Recently it will no longer accept the same
information it had previously. It is exhibiting the
characteristics of a text field instead, although it is
still a memo field. This was an Access 97 database which
was upgraded to XP. But it had been operarting fine under
the XP version until about three weeks ago.

The data is being entered through a form into a text box.
Click to expand...

Have you by any chance applied any formatting to field or text box? Set
the Format property? That will cause the control to treat the field as
if it were a text field, limited to 255 characters.
 
Is there anything in the Format property of the text box on the form or the
Format property of the field in the table? That can truncate at 255
characters.

If not, you may have a corruption in your database.
Make a copy, and try the Repair option (Tools | Database Utilities).

If that does not solve the problem, you may need to get Access to recreate
the file. Steps in:
Recovering from Corruption
at:
http://allenbrowne.com/ser-47.html
 
NancyD said:
I created a database with a memo field for large
comments. Recently it will no longer accept the same
information it had previously. It is exhibiting the
characteristics of a text field instead, although it is
still a memo field. This was an Access 97 database which
was upgraded to XP. But it had been operarting fine under
the XP version until about three weeks ago.

The data is being entered through a form into a text box.
Click to expand...


Did you make any changes to the form's RecordSource query?
If you use a memo field in any way that would cause it to be
compared to something (Distinct, Group By, Order By, Union)
then the query will return a truncated field.
 
I did have the field set to format to all caps. I will
remove that to see if it remedies the situation.

Thank you!!
 
Back
Top