Access Report Text Box Limit

I have an access report that refers to a memo field.  I've set the underlying field to memo and the query works.  But it's cut off in the textbox on the report.  The text box value is some internal spacings and the value.  I've set the field to grow but it still cuts off.

Help would be greatly appreciated.
Who is Participating?
mbizupConnect With a Mentor Commented:
There are several reasons that Memo fields may be truncated.  Take a look at this as a starting point for reasons and workarounds:
mattfmillerAuthor Commented:
This is great.  Thank you.  It was relating to my underlying subquery.
Glad you've resolved it :-)

Can you share what the specific issue was with the sub-query?
mattfmillerAuthor Commented:
It was the group function.  Switching it to first on the memo field resolved the issue.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.