Memo field in a query

  • Thread starter Thread starter Rob Derosier
  • Start date Start date
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?
 
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.
 
Back
Top