How to print dash ("-") for zero values

[Vaughan]

I want my Access report to print dashes instead of zeroes, with the dashes
lined up with the units. My custom format looks like this so far :

#,##0.000;(#,##0.000);

What can I enter in the "zero value" segment to make it sow a dash (minus
sign) instead of "0.000" when the value is zero?

 

[Stefan Hoffmann]

hi Vaughan,

I want my Access report to print dashes instead of zeroes, with the dashes
lined up with the units. My custom format looks like this so far :

#,##0.000;(#,##0.000);

What can I enter in the "zero value" segment to make it sow a dash (minus
sign) instead of "0.000" when the value is zero?

Take a look at the OH, it gives you this exampel:

$#,##0.00;($#,##0.00);"Zero";"Null"

The third parameter is what you need.


mfG
--> stefan <--

 

[John Spencer]

Try the following
#,##0.000;(#,##0.000);-

If that fails then try
#,##0.000;(#,##0.000);\-

Number fields and variables have 4 format sections (Positive, Negative, Zero,
and Null). If a section (other than null) is not specified, it inherits the
format from the prior section.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County