Query truncating memo field

[Van T. Dinh]

*Genrally*, if you use ORDER BY / GROUP BY or similar,
Access will truncate Memo Field values to max 255 chars.

Post details of your Tables, SQL String of your Query,
whether you need the Query to be updateable or not and
someone may come up with suggestions/solutions.

HTH
Van T. Dinh
MVP (Access)

 

[Ken Snell]

I usually use First as the choice for memo fields.

Call me slow, but how should I pull my memo field into a query? I thought

"Group By" was the standard generic. ??? Ach!

 

[Ken Snell]

By first, I mean in place of the group by. If you tried using First in place
of the memo field's fieldname, then yes you'd get the parameter prompt.

--

Ken Snell
<MS ACCESS MVP>

I tried First, but then it prompted for criteria when the query was used

for a report. I found that since I didn't need the Total options, I just
turned them off and it stopped truncating. Silly me.