oh point oh oh

[rob p]

I have an unbound text box with a =dsum(formula ...) . Decimal places set
for 2 and type of format is "standard" number.

How can I get 0.00 to show up in that field on the form if there is a zero
result?
Thanks.

 

[Fredg]

In the Control's Format property, write:
#,###.00;-#,###.00;0.00

The above will include a comma separator for thousands.
Use #.00 if you don't need a separator.

Look Up
Format property + Numbers and Currency Data Type
in access Help.