Not all entered information is visible in table fields

[Guest]

Text data entered into a form is truncated after about 200 characters in the
underlying table. The associated field in the table is a memo data type.
Subsequently, when a report is generated from the table, or a query, the data
is also truncated. Is there a way to set the field in the table to contain
all the text entered on the form?

 

[Dirk Goldgar]

Text data entered into a form is truncated after about 200 characters
in the underlying table. The associated field in the table is a memo
data type. Subsequently, when a report is generated from the table,
or a query, the data is also truncated. Is there a way to set the
field in the table to contain all the text entered on the form?

How sure are you that the text in the table is truncated? Did you open
the table directly and check out the field contents, or did you draw
your conclusions from the result of a query?

 

[Guest]

Hi Jim,

I believe the truncation occurs after 255 characters, not 200. Do you have a
format applied on the field? If so, try removing it. Here are some reference
KB articles:

http://support.microsoft.com/search...20&ast=1&ast=2&ast=3&ast=4&ast=7&mode=a&adv=1


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________