Maximum Report Field Size?

  • Thread starter Thread starter Sean H
  • Start date Start date
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,
 
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.
 
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?
 
Back
Top