Accounting Format for Field on Report

[Eagle2003]

I am trying to format a report field to accounting (called the accounting format in Excel, not sure about Access). In particular, I'd like the zero values to show as dashes (hyphens) rather than 0. My report is based on a query.

I have searched the board and google results and cannot find anything that tells me exactly how to do this.

Any help would be much appreciated!

Thank you.

 

[boblarson]

Set the text box's format to something like this (you can modify as you require):

$#,##0.00;($#,##0.00); -

 

[Eagle2003]

It's a beautiful thing...it worked. Thank you very much Bob!

 

[boblarson]

Glad we could help.