how can I suppress a line feed on a report if the line is null?

[MerlinEmrys]

I'm working on a report that has 10 possible fields -- each can have a rating
of 1, 2 or 3. I wan't to select and print ONLY those fields that have a
value of "2" without leaving blank lines where the non-printing lines would
be.

 

[Rick B]

set the "can shrink" property to TRUE for the controls you wish to shrink
when null.

 

[Marshall Barton]

I'm working on a report that has 10 possible fields -- each can have a rating
of 1, 2 or 3. I wan't to select and print ONLY those fields that have a
value of "2" without leaving blank lines where the non-printing lines would
be.

Add a line of code for each text box:

Me.textbox1.Visible = (Me.textbox1 = 2)

Then set each text box's Can Shrink property to Yes. Set
the detail section's Can Shrink property to Yes as well.

 

[Robbie Doo]

I have the same problem but the Can Shrik property doesn't work in my case.
Any help?

Here's my line that returns a value I'm looking for with spaces in between
lines.
=IIf([Status]="Active" And [due]>100,[Customer],Null)