I am using access 2003 and would like to know how to increase the number of characters in a text field on a report. See attachment.
Competent Performer
Windows XP 
Access 2003
I am using access 2003 and would like to know how to increase the number of characters in a text field on a report. See attachment.
MS MVP - Access Expert
Windows 7 Access 2010 (version 14.0)
Try setting the Can Grow property to Yes.
Boyd Trimmell aka Hitechcoach
Database Architect and Problem Solver
Microsoft MVP - Access Expert
25+ years specializing in Accounting, Inventory, and CRM systems
"If technology doesn't work for people, then it doesn't work."
Competent Performer
Windows XP Access 2003
The properties of both the report and query for those text fields are set to yes for can grow. I have come across this before but cant remember what the fix was. The answer came from this site only I think for forms.
MS MVP - Access Expert
Windows 7 Access 2010 (version 14.0)
Originally Posted by nashr1928
Also check the Can Grow property for the section with the control.
Boyd Trimmell aka Hitechcoach
Database Architect and Problem Solver
Microsoft MVP - Access Expert
25+ years specializing in Accounting, Inventory, and CRM systems
"If technology doesn't work for people, then it doesn't work."
Competent Performer
Windows XP Access 2003
I have checked a third time and found a couple of reports that had not been changed to can grow and that fix the problem. Thanks so much for your help. Much appreciated......... Rick
MS MVP - Access Expert
Windows 7 Access 2010 (version 14.0)
Rick,
You're welcome.
Glad we could assist.
Boyd Trimmell aka Hitechcoach
Database Architect and Problem Solver
Microsoft MVP - Access Expert
25+ years specializing in Accounting, Inventory, and CRM systems
"If technology doesn't work for people, then it doesn't work."
Line Return escape character
Posting Permissions
Reply With Quote