Memo field

[georgea]

When I enter data into a Memo field the data is being truncated to maximum
allowed for a Text field. Please advise on why this is happening and how to
fix it. I am using MS Access 2003 SP3. Thanks

George

 

[John W. Vinson]

When I enter data into a Memo field the data is being truncated to maximum
allowed for a Text field. Please advise on why this is happening and how to
fix it. I am using MS Access 2003 SP3. Thanks

George

This can happen if you have a Format set on the field (either in the table or
on the Form). Remove any Format property and see if that solves the issue.