Memo field in a query

R

Rob Derosier

I have a query that I am using for a report, and one field
is memo. The data for the memo stored in the table often
runs more than 255 characters, but when I run the query or
the report, it gets truncated to 255 like it was a text
field instead. Any ideas on how to get the entire memo to
display in the report?
 
J

John Vinson

I have a query that I am using for a report, and one field
is memo. The data for the memo stored in the table often
runs more than 255 characters, but when I run the query or
the report, it gets truncated to 255 like it was a text
field instead. Any ideas on how to get the entire memo to
display in the report?
Click to expand...

Be sure not to Group By or sort on the memo field! That truncates it.

Perhaps you could post the SQL of the query.
 

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

Make Table Query Truncating Memo Field at 255 Characters 1
disctinct query memo field 3
Query field size quandry 2
memo field in the select query 2
Totals query and Memo field 3
How can I convert text field to memo field in a query 10
Export to excel has character limit 3
Query -Maximum Field Length 2

Top