>I want to put a memo field on a report. I want to show the entire contents of the memo. So if the memo is lengthy, it may require 3 lines, if there is nothing in the memo i would like for it to require no lines (I do not want three blank lines). Is there any way to vary the length of the report field based on the length of data?
>
>thanks
>
>Brenda

Add the textbox to the report.
In its properties, check Stretch with overflow.