Why on Access is the report not picking-up all data from query?

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

Guest

I have completed the report from a query, the query contains information from
a table in memo format, and unfortunately the report is not showing all data
from the memo format.
 
My guess is that your field on your report is not big enough. Look at
the properties of the field in Design View. Change Can Grow to Yes and
then view your report. You should be able to see what is in your field
now.
 
Do you see "all data from the memo" when you view the datasheet of the
report's record source? If not, you probably have issues with phrases in
your SQL like DISTINCT or GROUP BY.
 
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

Memo field truncating in report 3
Weird problem w/ Group Header 3
Canshrink question!! 2
truncation of memo field supplied by DLookUp in a report 8
Exporting to word misses off data 4
Report control doesn't display all the characters in a query field 2
Report Can Grow not aligned horizontally 2
Report truncating MEMO column 1

Back
Top