G
Guest
What is the best way to hide a control if the value is null or 0? I tried an
If...End On Load but that didn't work.
If...End On Load but that didn't work.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Duane Hookom
Set the format property to a value that will not display any value. Search
Help on "Format Number".
Help on "Format Number".
G
Guest
Thank you for your help. I know how not to dislpay the number, but I am
trying to hide the label. It's for a discount line and I don't want people
asking how they can get a discount.
trying to hide the label. It's for a discount line and I don't want people
asking how they can get a discount.
D
Duane Hookom
Next time please provide more specifications so this can be answered in less
back and forth.
You can use code in the On Format event like:
Me.lblYourLabel.Visible = (Not Nz(me.txtYourTB, 0) = 0)
You can also substitute a text box for the label and use a control source
like:
=IIf(Nz(me.txtYourTB, 0) = 0,Null, "Your Caption")
back and forth.
You can use code in the On Format event like:
Me.lblYourLabel.Visible = (Not Nz(me.txtYourTB, 0) = 0)
You can also substitute a text box for the label and use a control source
like:
=IIf(Nz(me.txtYourTB, 0) = 0,Null, "Your Caption")
G
Guest
Thank you for your help! That is what I was looking for.