Memo field

G

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
 
J

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
Click to expand...

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.
 

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 7
appending more than 255 characters into a Memo field 13
Memo vs. Text 255 8
Memo Field in Access 2007 - On Lose Focus, Field Jumps To Top 1
Database for VBA 6
insert memo feild into a memo field truncates at 255 characters - 4
Wordpad field 1
How to Print a large memo field on multiple pages without losing . 1

Top