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.
 
thanks fred

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

Look up
Format Property + Number and Currency datatype
in Access help.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Case Approach Not Consistant 2
Access Textbox - Hide Cursor 0
text box control source 2
Text box incomplete in GroupFooter 0
Total not correct in Footer 1
Can't Hide Text Box 5
Report Totals on Text Boxes in Sub Report 2
Conditional Footer Code 5

Back
Top