Long Reports

[Guest]

I have a summary report that will have upwards of 200 individual items of
data on it. Sometimes, this data will be blank. If the data is blank, is
there a way to suppress the printing of the associated label/text box using
an "if" statement, so that I dont have large gaps of blank space on the
report?

Thanks

 

[Marshall Barton]

I have a summary report that will have upwards of 200 individual items of
data on it. Sometimes, this data will be blank. If the data is blank, is
there a way to suppress the printing of the associated label/text box using
an "if" statement, so that I dont have large gaps of blank space on the
report?

Well, it's possible, but how depends on how you've laid out
the report. If each value is on a "line" by itself, then
you can set it's CanShrink property to Yes. Be sure to also
set the section's CanShrink property to Yes.

If a text box has an attached label, there are several ways
to deal with the label. One way is to change the label
control to a text box with an expression like:
=IIf(thefield Is Null,Null,"label caption")

Another way is to add a line of code for each text box to
the section's format event procedure:
Me.label.Visible = Not IsNull(Me.textbox)