access 2013 the currency cells to show empty when calling for 0.00

[HAWKEYE]

Using Access 2013 working with a currency formatted db database, I need to have the cells that are calling for $0.00 to show a blank cell. One of the websites stated to go to file-options-advance but having problems locating this.. MS word and Excel have an advanced settings option in the options section, any help would be appreciated.

[pbaldy]

Note the options in custom formatting:

https://msdn.microsoft.com/en-us/lib.../ff836697.aspx

im assuming that by "calling for" you mean they have a value oz zero.

[ItsMe]

Also, IIRC, the predefined Currency format will use bankers rounding. If you add your own $ to a string when formatting a double you can have better precision. I would have to review the options to offer better advice. I just thought it was worth mentioning so you can look into it on your own and determine what is best for your situation.

[HAWKEYE]

Using Access 2013 working with a currency formatted db database, I need to have the cells that are calling for $0.00 to show a blank cell. One of the websites stated to go to file-options-advance but having problems locating this.. MS word and Excel have an advanced settings option in the options section, any help would be appreciated.

A little more digging: went to Designview>field properties> default value was set to zero removed the (0), have good evening.

[HAWKEYE]

A little more digging: went to Designview>field properties> default value was set to zero removed the (0), have good evening.