invisibility

E

EddieC

Can anyone tell me how to make a Label invisible if the field i
represents is zero or null
 
M

Marshall Barton

EddieC said:
Can anyone tell me how to make a Label invisible if the field it
represents is zero or null?


Several ways to do that.

You can use a line of code in the Format event procedure of
the section containing the label's text box:
Me.thelabel.Visible = Not IsNull(Me.thetextbox)

Alternatively, you can change the label to a text box with
an expression like:
=IIf(thetextbox Is Null, "", "caption from label")
 
Top