By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
460,031 Members | 1,248 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 460,031 IT Pros & Developers. It's quick & easy.

How to set a field to blank when it's displaying 0.00

P: 1
I'm writing a report that shows several rows whose values are 0.00 when not used. Trying to hide them unless they are used. I know you can set Format to #;-# and show nothing if the field is set to 0, but if it's 0.00 it will still show .00 I need the two decimal places, so setting Decimal Place to Auto is not an option.

How can you get rid of the decimals?
Jan 16 '15 #1

✓ answered by Stewart Ross

Change the Decimal Places value back to Auto. Use the Format property of the textbox concerned instead.

You can then define a custom display format in the sequence
Expand|Select|Wrap|Line Numbers
  1. (positive values format); (negative values format); (zero values format); (null values format)
All you need to display non-zero values to two decimal places but zeroes as blank is to set the Format property of the textbox to:

Expand|Select|Wrap|Line Numbers
  1. 0.00; -0.00;
Please note that if you leave the decimal places property set to 2 it will override this custom format, so please change it back to auto accordingly before you make the format change.

-Stewart

Share this Question
Share on Google+
1 Reply


Expert Mod 2.5K+
P: 2,545
Change the Decimal Places value back to Auto. Use the Format property of the textbox concerned instead.

You can then define a custom display format in the sequence
Expand|Select|Wrap|Line Numbers
  1. (positive values format); (negative values format); (zero values format); (null values format)
All you need to display non-zero values to two decimal places but zeroes as blank is to set the Format property of the textbox to:

Expand|Select|Wrap|Line Numbers
  1. 0.00; -0.00;
Please note that if you leave the decimal places property set to 2 it will override this custom format, so please change it back to auto accordingly before you make the format change.

-Stewart
Jan 17 '15 #2

Post your reply

Sign in to post your reply or Sign up for a free account.