In the OnFormat event of the detail section, set the height of the other
fields to the height of the memo field:
Me!MyField.Height = Me!MemoField.Height

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications

www.pcdatasheet.com


"p8md" wrote in message
...
I have made a Report from my data which ended up looking like a
spreadsheet.
It has multiple fields side-by-side within the detail section. One of the
fields is a memo field that I have set "Can Grow" to yes because some of
the
data can become lengthy.

When the memo field grows vertically, the other fields next to this field
does not grow with it and makes the Report look messy. Is there a way to
make these other fields grow when the memo field grows?

Thanks,
Mark