Expand fields on access database report for only lines that need it
I have a report in access and some of the notes on some records have info that need to be expanded underneath them.
I know i can expand all of them and fit the info in, but then i have a report that takes up many pages. Can i expand only the ones that have too much info to fit into one line?
on the attached image you can see that BAM 2381 is cut off on the notes field. i want to that any any other that get cut off to expand underneath. BUT only the ones that need it
Untitled-picture.png
I know i can expand all of them and fit the info in, but then i have a report that takes up many pages. Can i expand only the ones that have too much info to fit into one line?
on the attached image you can see that BAM 2381 is cut off on the notes field. i want to that any any other that get cut off to expand underneath. BUT only the ones that need it
Untitled-picture.png
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
peter57r
Set the Can Grow property for that control and for the section it is in (?detail section) to Yes.
4 Seconds!! ^&**( (:-)
peter57r, I had just read a response from you to another Q so I figured I had a chance to sneak in under your radar. ;)
OM Gang
OM Gang
No problem - I'm just getting too old to type quickly!