How I change the format 0 to -

O

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
 
K

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"
 
M

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
Click to expand...


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

0.00;-0.00;" - "
 
Top