Displaying more than 255 characters in a report

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

Guest

I am trying to create a report based on a query. My report will not display
the entire content of the field whose type is 'Memo' with more than 255
characters. How do I get the report to display all the information in the
field.
 
Arlsha said:
I am trying to create a report based on a query. My report will not
display the entire content of the field whose type is 'Memo' with
more than 255 characters. How do I get the report to display all the
information in the field.
Click to expand...

Chance are the text is being truncated by the query , not the report. The
exception to this would be if you are applying a format property to the
TextBox. You can't do that and display an entire memo field.

In your query make sure you are not using DISTINCT or Grouping on the memo
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

text box in report is truncating memo field at 255 characters 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Memo Field is truncating to 255 Chars 6
Maximum Report Field Size? 2
Reports: memo field won't display more than 255 characters 1
FIeld with more than 255 char on report 0
Memo Fields Only Displays 255 Characters 4
Subreport only displays 255 characters. 2

Back
Top