Automatic height in detail section

[Tiannra]

I haven't used Access before and am trying to generate a Report from a Query.

I have built the Report successfully, however am having trouble adjusting the height of the rows in the Detail Section.

I want the row height to fit the text, if there are two lines in the row, then have an automatic height of two rows. If only one line in the row, then automatically adjust the height to one row. Like wrap text in Excel.

In my Report, I only have the one row height, adjust in Detail by using the mouse to drag up the detail section as much as possible to the text. Is there another way?

I hope I have given enough detail of what I'm trying to do for someone to help me.

I don't want to have to transfer all this text over to Excel just to change the height of the rows.

Hope there is someone who knows what I'm talking about.

Cheers,
Tiannra

 

[SydneyGeek]

Set the CanGrow and CanShrink properties to Yes, in all controls in the Detail section and the Detail section itself.

Denis

 

[Tiannra]

Thanks for that. I only had those as Yes in the detail section, not in each individual text box in the detail section.

Wonderful.

Yay!

 

[SydneyGeek]

You're welcome

Denis