> I have also tried defining the Variable to be (ifnull(snote,null,('Line Item
> Notes'&snote))) and placing just the variable memo on the second line, but I
> get the same problem of space. So it appears that a variable memo, when
> null, does not allow the dynamic height to shrink into the space that it
> occupies. I have also tried variable text with the same problem. Is there a
> work around or something I am not setting correctly so that I can get the
> results I am looking for ?
The first question I have is: you don't explicitly mention setting the STRETCH
property of the second memo field, the one containing the words 'Line Item
Notes'. That needs STRETCH ON too. Also, double check that you are really
using a MEMO field, not a DB Label field (which won't stretch).
Having done that, make certain that both memo fields are exactly the same
height and have exactly the same top.
Finally, remove the expression from your report, and try setting the variable
before you print the report. When NULL, do you get the compression you expect?
If not, it sounds like there is a problem with Variable Memos shrinking
properly.
--
Larry
