Don't even try this solution since it is bound to fail. Marsh has provided
the recommended solution.

--
Duane Hookom
MS Access MVP


"p8md" wrote in message
...
Thanks so much for your help, but you may need to "dumb it down" so I
understand. This is what I unsuccessfully attempted. It does NOT give
errors, just does nothing.

Right click on the Detail section and chose Properties. In the On Format
line I chose Event Procedure. Right Click on the Detail Section again and
chose build event. This brought up VB. Within the Detail_Format, I
entered
Me!ProcessInstr1.Height = Me!ProcessInstr8.Height. ProcessInstr1 is the
smaller field and ProcessInstr8 is the larger memo field.

Below is the Detail_Format section from my VB code...

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

Me!ProcessInstr1.Height = Me!ProcessInstr8.Height

End Sub

Any further help will be much appreciated,
Mark

"PC Datasheet" wrote:

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