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.