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
LVL 2
bignadadAsked:
Who is Participating?
 
omgangConnect With a Mentor IT ManagerCommented:
Set the Can Grow property for that field/control to Yes.  You must also set the Can Grow property for the report section (Detail Section) to Yes.

OM Gang
0
 
peter57rCommented:
Set the Can Grow property for that control and for the section it is in  (?detail section) to Yes.
0
 
peter57rCommented:
4 Seconds!! ^&**(  (:-)
0
 
omgangIT ManagerCommented:
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
0
 
peter57rCommented:
No problem - I'm just getting too old to type quickly!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.