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.
 
Ad

Advertisements

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

Top