Hide Text Box When 0

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a text box in a footer that has an expression as a control source. I
want the value hidden when it is "0". How can I do this? Thanks.
 
I have a text box in a footer that has an expression as a control source. I
want the value hidden when it is "0". How can I do this? Thanks.
Click to expand...

Set the Format property of the control to:
#;-#;""

Look up
Format Property + Number and Currency datatype
in Access help.
 
Back
Top