memo field expansion in details section of report?

[Haggisns]

Hi,

I have a Access 2003 report.

I have added a memo field to the details section. I have carriage returns in
the field and some of the records returned have memo fields with anywheres
from 1 to 15 carriage returns.

I would like to dynamically expand the vertical size of the details section
to only show the required space to show all 15 lines in the memo field, if
this is possible.

So that if I had 3 detail lines as so:

detail line 1,: memo field has 15 carriage returns
detail line 2: has 1 carriage return

the detail section will really only be approximately 16 lines in height not
30.

Is this possible?

thanks

Chris

 

[Haggisns]

Crikey!

Can field expand YES !

too easy

Chris