My memo field in my data entery form truncates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

1. I created a memo field in a form that I use ,but when I try to enter more
then 3 simple sentences not much longer then this one it truncates the 2nd or
3rd statement or will not let me enter any data.
 
1. I created a memo field in a form that I use ,but when I try to enter more
then 3 simple sentences not much longer then this one it truncates the 2nd or
3rd statement or will not let me enter any data.
Click to expand...

You cannot create a memo field *in a Form*. Forms don't contain
fields, and do not store data! Data is stored in Tables, using forms
as a tool.

If the table field is a Memo field, just be sure that neither the
table nor the form has any Format property set on the field; any
formatting will truncate the data to 255 bytes. Similarly, don't apply
any Input Mask.

John W. Vinson[MVP]
 
Back
Top