Memo Field Not Showing All Data in Report

[Tophan]

I'm using Access 2010 and for the first time encountered this issue - the memo field in a report is cutting off the data and acting more like a text field with a limited entry.

The field of the referencing table is set to memo; the properties in the report are set to Can Grow = yes. I'm seeing all the data in both the table and corresponding query but it is cutting off in the report.

Has anyone ever had this problem and any suggestions on how to fix it?

 

[Awesomo]

Hi.
Is the detail of the report also set to Can Grow?
Also, is it cutting it off after the same number of lines in all cases?

 

[Tophan]

Hi...Can Grow is set to Yes and it is cutting off at the same point each time. I increased the size of the text box (both width and height) but it's just stopping at the same word as if there is a limit to the text entry.

I did over the whole report last night and so far no problems...just not sure why that happended,

 

[Awesomo]

So its working fine now?
Its happened me a few times, where I just did a new report and the strange behaviour went away. Not very scientific though!

 

[Minty]

If your underlying query performs any grouping it will truncate a memo field. Have a look here for the bottom line http://allenbrowne.com/ser-63.html