Formatting currency in a subform field after value set via macro

[Benzer420]

I have a parent form and a sub-form. On the parent form is a date field [JOINED] and on the sub-form there is a date field [DATE PAID] and a field [BQ JOINING FEE] with a default format of currency.


I created a macro to set the value of [BQ JOINING FEE] to 0 if ([DATE PAID]>[JOINED]+60). It sets the value to 0 as required but I am unable to get it to format the result as currency.

Many Thanks in advance.

Benzer420

[ranman256]

on the form, did you set the [BQ JOINING FEE] text box format = 'currency' ?

or [BQ JOINING FEE] =format(0,"$0.00")