memo versus text field

[Frank Bobak]

If you use a text field you are limited to 255 characters
and a memo field is limited to +/- 65,000 characters.
When you include the field in a query it cuts off at 255.
I need to include the field to show in a report. How do I
show the contents of the entire field?

Thanks

 

[Rick B]

pulling a memo field to a query and then to a report does NOT cut off data.
I just tested it and it pulled my entire memo field.

 

[John Vinson]

If you use a text field you are limited to 255 characters
and a memo field is limited to +/- 65,000 characters.
When you include the field in a query it cuts off at 255.
I need to include the field to show in a report. How do I
show the contents of the entire field?

Thanks

It only truncates the memo field if you:

- sort on the field
- group by the field in a Totals query
- specify a Format on the field

If you don't do any of these things, you should see the full memo
field. Just including it in a Query does NOT truncate it.

If you're using a Totals query as the basis for the report, use First
as the grouping operator for the memo field rather than Group By.
Hopefully you don't actually need to group by the *contents* of the
memo field (this would occur only if you had records which were
identical in all other fields and only had differences in the memo).

John W. Vinson[MVP]

 

[Douglas J. Steele]

It only truncates the memo field if you:

- sort on the field
- group by the field in a Totals query
- specify a Format on the field

I believe it also truncates if you use SELECT DISTINCT, or UNION.

UNION ALL will solve the problem for the last case.

 

[John Vinson]

I believe it also truncates if you use SELECT DISTINCT, or UNION.

wups! Right you are, of course!

John W. Vinson[MVP]