Report not to show $0.00

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
 
S

Steve Schapel

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;;
 
B

Bob Vance

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

Top