Access Truncating Output in Memo Fields in Report

I am trying to output values in some memo fields in a table to a report. However, the output of the text fields in the report is being truncated to 255 characters. How can I get it to display the full output? I have tried setting the "can grow" property to "Yes", but it still doesn't work.
geeta_m9Asked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:
if you are using a query as record source of your report, see this link for possible solution

http://allenbrowne.com/ser-63.html
0
 
geeta_m9Author Commented:
I don't think my issue is related to any of the problems that were outlined.  The output from the query is fine. It is only in the report where the output is being truncated.
0
 
Helen FeddemaCommented:
I have an Access 2010 report that displays data from a memo field (much more than 255 characters) in a textbox, without truncation, in a subreport bound directly to a table containing the Memo fields (not a query).  What type of report is this?  Can you upload the database?
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
geeta_m9Author Commented:
It is just a regular Access report and the input is coming from a table that has a memo field. In the report, the text box where the data is displayed is bound to the memo field as the control source, but truncates the data displayed within it.
0
 
Bill RossCommented:
Hi,

On the report, make sure the can grow property of the control and the section where the control resides (detail probably) is set to true.

See if that helps.

Regards,

Bill
0
 
Helen FeddemaCommented:
If that doesn't work, you could try making a subreport bound directly to the table with the Memo field, linking by an appropriate field value to the main report's record source.  The truncation may be caused by passing the Memo field data through a query.  Test first by making a quick report based directly on the table.
0
 
geeta_m9Author Commented:
Sorry for not responding earlier but I was abroad. I found out that the cause of the problem was due to the query having an aggregate function which was one of the factors int the list referred to  by Capricorn1. When I removed the aggregate function, the entire contents of the field were displayed.
0
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.