Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sub-Report text field truncates data at 255 characters with can grow = "Yes"

Status
Not open for further replies.

Pack10

Programmer
Feb 3, 2010
495
US
I have an access report that contains several sub reports. In one of the sub reports, i have noticed two fields which have "can grow" set to yes are that are truncating the text at 255 characters on a memo field. I thought this would display the full field's data.
 
I solved this by....

Choose First instead of Group By under the memo field. The aggregation is still preformed on other fields from the table, but not on the memo, so Access can return the full memo.

The field name changes (e.g. FirstOfMyMemo), so change the name and Control Source of any text boxes on forms/reports.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top