Cut off memo field (1 Viewer)

[Fasopus]

So in one of my reports I use a memo field. However when the field is queried and placed into the report it is cut off at what I am assuming is 250 characters. I have had this happen in the past but I fixed it by setting the memo fields total property in the query to First instead of Group By. However now when I change this property and run the Query it crashes Access. Is there any other way around the truncation of the memo field?

 

[boblarson]

Use two queries. In the first, use all of the fields EXCEPT the memo field and have the criteria on that one. Then use another query to pull all of those fields from that query into a new one and then add the table in with the memo field, join on the primary/foreign keys and use the memo field.

A query with a memo field cannot have criteria directly on it or else you run into the 255 character cut off.

 

[Fasopus]

Cool beans! Thanks for the tip Bob!