Hide Text Box When 0

B

BarryC

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.
 
F

fredg

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