Printing very long memo fields in a report

P

Portia

I have memo fields of up to 800 characters in my DB. When I run a query to
select and sort that data only the first 255 characters of the field show. Is
there a way to show all 800 characters on my report?
 
D

Dave M

Is your query set for unique values? In earlier versions, Access simply
refused to run unique values queries that included memo fields (presumably
because it can't index them) but recent versions (2003) seem to run the
query but reduce the memo field to a text field. If the query needs to use
unique values, you will have to leave out the memo field and then create a
new query based on the unique values one and the original table, joined on
the key field, to get the memo data.
 
T

Tom Wickerath

Have you applied any type of formatting to your memo field?

ACC2000: Formatted Memo Field Appears to Truncate Data After 255 Characters
http://support.microsoft.com/?id=259893


Tom
___________________________________


I have memo fields of up to 800 characters in my DB. When I run a query to
select and sort that data only the first 255 characters of the field show. Is
there a way to show all 800 characters on my report?
 
Top