p8md wrote:

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?


This is a tricky situation. Your controls have no need to
grow so their border stays where it was. Actually, you
don't want the control to grow, you only want the lines
around the control to be even. Since that won't happen
automatically, you need to set the border style for all of
them to transparent and draw the lines yourself using the
Line method.

Since the memo field's (and the detail section's) final
height is not known at the time of the Format event, you
have to do this in the Print event.

If you want to use a ready made code solution for this, use
the PrintLines file at www.lebans.com

--
Marsh
MVP [MS Access]