memo field in the select query

[inungh]

I have a memo field in my select query and only return 255 characters.

Do I need specify any return type using select query for memo field?

The query is for the report. The report does not show all the
information in the memo field.


Your help is great appreciated,

 

[John Spencer]

If the memo field is returning only 255 characters, you may have
-- sorted by the memo field
-- returned distinct rows
-- used a totals query and grouped on the memo field
-- applied formatting to the field or to the control that is bound to the field.


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Marshall Barton]

I have a memo field in my select query and only return 255 characters.

Do I need specify any return type using select query for memo field?

The query is for the report. The report does not show all the
information in the memo field.

Check your query for thibga kike Distinct, Group By, Order
By, etc. that require the memo field values to be compared.

Using the Format property of the memo field's text box on
the report will also truncate a long string.