• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1043
  • Last Modified:

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.
0
geeta_m9
Asked:
geeta_m9
1 Solution
 
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now