Aug 22 2009, 11:29 AM
Hello, I have a report where the Detail section is formated into 4 columns under the 'Page Setup' -'Columns" tab.
On the Access Report for the 'RoomName" field I have 'Can Grow' and 'Can Shrink' set to YES.
Problem: the text sometimes gets truncated even if it also grows to the next line...
Main Office Conference Roo (truncates "Room" instead of growing to the next line!)
Theatre Dressing Room Clo (truncates "Closet" instead of growing to next line with 'B")
Is there a way to fix this in ACCESS or do I need to look to another solution...
Aug 22 2009, 04:19 PM
Let's eliminate the obvious first. Is the detail section itself set to "Can Grow" and "Can Shrink"?
I'm looking at the fact that you have columns defined as well. Is this an issue at the bottom of a column, or anywhere within a column?
Aug 22 2009, 09:17 PM
Hello, to answer your first question, both the detail section and the RoomName field si set to "can grow' and 'can shrink'.
This issue happens anywhere within a column.....
Do you want me to send a sample database file? I soooooooo appreciate your help... Maggie
Aug 22 2009, 09:25 PM
Sure, upload it as an attachment. That is often the best way to trouble shoot the unusual problems anyway.
To attach files, make a copy with all sensitive data removed and "zip" it into a zip file. Attachments need to be <500KB.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here