Memo Field in Table Truncated in query results and in report

B

Bill Liddell

I have a database where I have a memo field defined for an open text
comments. The all the data shows in the table's memo field. But when I run
the query and the subsequent report it truncates the data to about 255
characters, which is the Text field max rather than the memo field length. I
am probably missing something simple, but I am stumped.
 
B

Bill Liddell

Ok... Never mind. I got it. I put a group by in the query. Took it out and
the field displays all characters now. Got the tip from another comment
here, very helpful. Thanks guys.
 

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

Data in Memo Field is truncated 1
Union query truncates data 9
Memo Field Text Hidden 2
Unmatched Query and Memo Field 5
Memo Length Restriction 3
Memo field in a table 1
truncation of memo field through officelink in reports to windows in xp 1
memo versus text field 4

Top