VB with Reports

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
 
L

Les

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