Report not to show $0.00

  • Thread starter Thread starter Bob Vance
  • Start date Start date
B

Bob Vance

On my report I have a text box , what I want to achieve is if the result is
$0.00 I want nothing to show (Blank)
I cant use Conditional format as I have alternative line shading
 
Bob,

You can use the Format property of the textbox to achieve this. For
example, you can set it like this:
$#,##0.00;-$#,##0.00;;
 
Thanks Steve :)


Steve Schapel said:
Bob,

You can use the Format property of the textbox to achieve this. For
example, you can set it like this:
$#,##0.00;-$#,##0.00;;
 

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

Back
Top