How I change the format 0 to -

[Oswaldo Lopez]

In access I cant change the cero format in a report, shows 0, and i need in
the cero spaces shows " - " or blank
Please excuse my english

 

[Ken Snell \(MVP\)]

Use the Format property of the textbox -- it can have up to four items in
it:

x;x;x;x

First value is how to format positive numbers. Second value is how to format
negative numbers. Third value is how to format zero value. Fourth value is
how to format Null value.

So, for example:

0.00;-0.00;-;"empty"

 

[Marshall Barton]

In access I cant change the cero format in a report, shows 0, and i need in
the cero spaces shows " - " or blank

Set the text box's Format property to something like:

0.00;-0.00;" - "