Memo field in a Report

[Jacob]

I would like to know if there is a way to auto expand a memo field appearing
in a report based on how much text is in it? Some lines have only a small
amount of text appearing in the memo field and others have several lines.
Can this be done?

 

[Allen Browne]

Open the report in design view.
Right-click the memo text box, and choose Properties.
Set the CanGrow property to Yes.

You may also need to set the CanGrow property of the (Detail?) section to
Yes. CanGrow will not work correctly if other controls are overlapping the
memo vertically.

 

[Jacob]

I have the Can grow set in the properties of my Memo field in the report.
However, you lost me on setting it to CanGrow property of the Detail? Not
sure what or where you are referring to there?

 

[Fons Ponsioen]

In the Detail Allen was refering to the detail band. When
you have the report open in the design view you will have
various bands such as header, footer, detail etc. you can
set the properties for these bands by right clicking on
the thick line above these bands and selecting properties.
The can grow and can chrink properties of the detail band
may need to be set to yes. Play with these properties and
see what gives you the desired result.
Hope this helps.
Fons