Maximum Report Field Size?

S

Sean H

I'm working with a database that occasionally uses text fields larger than
255 characters, so I changed to table design of those fields to "memo". Now
when I have a report of that memo field I'm pretty sure its cutting it off at
255 characters. Is there a way to make the text display on the report
greater than 255 characters? Thanks,
 
D

Duane Hookom

This depends on if the field value is being truncating in the report's
record source query or in the report control. The query will possibly
truncate the value if the SQL contains phrases like "DISTINCT" or "GROUP BY"
or "UNION". If the query is okay, the issue might be which section in the
report contains the memo and if the control has anything in the Format
property.
 
D

Douglas J. Steele

Do you have any formatting set for the text box (or for the field in the
recordsource)? Is your report based on a Union query? Are you sorting on the
memo 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

Export to Excel Cuts Off Data 1
text box in report is truncating memo field at 255 characters 2
Size of memo contro on report 2
Memo field truncated in MS Access Report 0
Memo field is truncating in group heading of an Access 2007 report 3
How can I expand the number of characters displayed from a memo f. 2
How do I force a memo field to print all text in reports? 2
Memo Field in a Report 2

Top