VB with Reports

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Galsaba - 15 Apr 2004 11:36 GMT

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

Reply to this Message

Les - 16 Apr 2004 19:35 GMT

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)

>-----Original Message-----
>I want to display a certwin field in my report only if the value is not 0.
[quoted text clipped - 7 lines]
>Joe
>.

Reply to this Message