Memo field not fully displaying

C

CathyGagl

I'm trying to display a memo field from a table in a text
field on a report and it is truncating. I've updated my
system with Service Release 1/1a and Service Pack 3, to no
avail. I've made sure that the field is set 'to grow' at
every level. What else can I try?

Thanks for any suggestions!
Cathy
 
D

Duane Hookom

Does the full text appear when viewing the datasheet of the report's record
source? If not, remove any phrases like "DISTINCT" or "DISTINCTROW" or
"GROUP BY".
 
C

CathyGagl

THANK YOU!!!

It was the Group By that was causing the problem! I would
have never guessed!

Cathy
 

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
How to Print a large memo field on multiple pages without losing . 1
Memo field is truncating in group heading of an Access 2007 report 3
Memo field truncating in report 3
truncation of memo field supplied by DLookUp in a report 8
CanGrow with Memo fields? 2
Memo in Report causing blank pages/other issues 5
conditional format truncates memo field 1

Top