Subreport only displays 255 characters.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

A report with a memo field displays fine, but when that report is used as a
subreport, only 255 characters are shown in the section.

What is controlling this? How do I fix it?
 
Check the subreport's record source datasheet view to see if the field is
being truncated in the query. If so, remove any "Group By", "Distinct", etc.
If you can't find the issue, come back with the SQL view.

Also, setting any format property of the control will truncate the field.
 
You must log in or register to reply here.

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
text box in report is truncating memo field at 255 characters 2
Maximum Report Field Size? 2
Export to Excel Cuts Off Data 1
SynNeed to account for null values in subreports 2
Access How to prevent subReport from breaking across pages? 1
Conditional display of subreport 6
Reports: memo field won't display more than 255 characters 1

Back
Top