I need to disply 0.00 on report if blank

  • Thread starter Newf via AccessMonster.com
  • Start date
N

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

Marshall Barton

Newf said:
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???
Click to expand...


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.
 
Top