VB with Reports

  • Thread starter Thread starter Galsaba
  • Start date Start date
G

Galsaba

I want to display a certwin field in my report only if the value is not 0.
In the case the value of the field is 0, I do not want to show neither the
field label or the field value. If the value is not 0, I want to display in the
report
both the label and the value.

Thanks,

Joe
 
You could make both the label and the field text boxes.
Then, in the controlsource for the text boxes, build
expressions:

=IIF(fld=0,"","Label") and
=IIF(fld=0,"",fld)
 
Back
Top