oh point oh oh

  • Thread starter Thread starter rob p
  • Start date Start date
R

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