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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
MerlinEmrys said:
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.
Click to expand...


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.
 
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)
 
Back
Top