I need to disply 0.00 on report if blank

[Newf via AccessMonster.com]

I have this code in there now:
0.00;"Negative "0.00;"ZERO";"Not Specified"

This is showing ZERO in the field now. I changed it to this:
0.00;"Negative "0.00;"0.00";"Not Specified"
And now it shows 0.00

Will this be a text field now?? Can I still use this in calculations???

Thanks in advance

Newf
~Everyone needs a Newfie as a friend~

 

[Marshall Barton]

I have this code in there now:
0.00;"Negative "0.00;"ZERO";"Not Specified"

This is showing ZERO in the field now. I changed it to this:
0.00;"Negative "0.00;"0.00";"Not Specified"
And now it shows 0.00

Will this be a text field now?? Can I still use this in calculations???

Setting the Format property has no effect on the data. It
will not change the value or its data type, so all
calculations will work the same as if you let Access choose
the format.