Why does a memo field only print 255 characters on a report?

G

Guest

I have a field defined as a memo field. Yet, when I display it on a report,
it only prints 255 characters.
 
G

Guest

Yes!. The Can Grow property is set. If I display the field on a form, all the
text is displayed. However, it only appears to print 255 characters on a
report.
 
R

Rick Brandt

zoomobile said:
Yes!. The Can Grow property is set. If I display the field on a form, all the
text is displayed. However, it only appears to print 255 characters on a
report.
Click to expand...

Look at the RecordSource (table or query) of the report directly. Do you see
all the characters there?
 
G

Guest

Rick,

I see a little progress. The report reads a query pulled from multiple
tables. If I look at the results of the query,my field of interest is
truncated. All the data is there in the original table. Somehow, a query may
have a limit of 255 chracters for a memo field.

I wonder if there is a way to get around it. My field of interest contains
directions to get to an address. Thanks for your help.
 
R

Rick Brandt

zoomobile said:
Rick,

I see a little progress. The report reads a query pulled from multiple
tables. If I look at the results of the query,my field of interest is
truncated. All the data is there in the original table. Somehow, a query may
have a limit of 255 chracters for a memo field.

I wonder if there is a way to get around it. My field of interest contains
directions to get to an address. Thanks for your help.
Click to expand...

If your query is grouping on the memo or is using DISTINCT then the memo will be
truncated. Also make sure there is no format being applied to the field by the
query.
 
D

Douglas J. Steele

Rick Brandt said:
If your query is grouping on the memo or is using DISTINCT then the memo
will be truncated. Also make sure there is no format being applied to the
field by the query.
Click to expand...

For that matter, if he's using UNION (rather than UNION ALL), I believe the
memo field is treated like a text field.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

text box in report is truncating memo field at 255 characters 2
Maximum Report Field Size? 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Reports: memo field won't display more than 255 characters 1
Export to Excel Cuts Off Data 1
Size of memo contro on report 2
Memo Field is truncating to 255 Chars 6
Memo field is truncating in group heading of an Access 2007 report 3

Top