auto-fit column width or continue on to next line

[rmulder]

I have a report where I'm trying to cram a lot of info into the width of one page. i have some fields that will have data that gets hidden like the "pickup/delivery location" field. is there a way to get access to expand the height of the field automatically to display the info on tow lines. I would compare this to the "wrap text" feature in excel. i fear it's not there. if so, any suggestions. here's a screen cap. thanks!!!

 

[rmulder]

wow, i didn't try hard enough. i found the answer to my own question. set "can grow" to "yes" in the property sheet!

 

[vbaInet]

Be careful with how you set can grow. If you didn't set a character limit on each of your fields and your user enters a rather long text then you will end up having undesired results.