problem with calculations in a form.

[terry6582]

Have a DB with a form to collect data. Have a problem with a calculation on the form. The data entry on the form look similar to this example:

check box Pre registration for couple. cost

the formula in the query look like this: prereg: IIf([adults]=-1,IIf([received]<DateValue([last_prereg_date]),Val([fee_couple]),[couple_late]),"$0.00 “)



The formula will calculate the correct amount and put in the form in currency format. However, it only displays the exact amount not in currency format.

properties for the field in the form is set for currency with 2 decimals. When the box is not checked it will display with the default data in the formula ($0.00)

What do I need to do to this formula to achieve the correct format: currency ($150.00) instead of 150 currently displayed

Help!!

Thank you!

[pbaldy]

Just put 0 in the false clause instead of in quotes. That makes it a string value, thus a numeric format won't affect it.