Can Shrink

[Guest]

I need help with a report that consist of column fields that may or may not
have data in them depending on the patient treatment plan chosen and what the
therapist uses. I have used the following formula for the the labels (text
fields) and have set the Can Shrink to yes for all of the fields.

=IIf(IsNull([MethodE])," ","MethodE")

The result is that the empty fields/labels do not show but the space remains
on the report. How do I get the report to shrink depending on what fields
have been completed?

You help is greatly appreciated.

 

[Steve Huff]

Have you tried:

=IIf(IsNull([MethodE]), Null,"MethodE")

--Steve Huff