Prev: Number format resulting from an aggregate query
Next: Total count for crosstab query
From: inungh on 2 Jul 2008 09:12
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,

From: John Spencer on 2 Jul 2008 10:40
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

inungh wrote:
> 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,
>
 | 
Pages: 1
Prev: Number format resulting from an aggregate query
Next: Total count for crosstab query