Changing to the currency format

[benonibriggs1978]

Hi,
In a desperate situation and hoping someone might be able to help. I
have this formula set up in a form:

=IIf([Text14]>[Text12],[vendor Name] & " " & "spend" & " " & [Month] &
" " & "YTD" & " " & "is" & " " & [Text14]-[Text12] & " " & "more
compared to this time last year",[vendor Name] & " " & "spend" & " " &
[Month] & " " & "YTD" & " " & "is" & " " & [Text12]-[Text14] & " " &
"less compared to this time last year")

And it shows the results below:

Fallon London Ltd spend July YTD is 1904570 more compared to this time
last year.


How can I change 1904570 to the currency/decimal places format? This
was derived from the[Text14]-[Text12] fields.

Can anyone help please.Thanks

Regards,

 

[Marshall Barton]

In a desperate situation and hoping someone might be able to help. I
have this formula set up in a form:

=IIf([Text14]>[Text12],[vendor Name] & " " & "spend" & " " & [Month] &
" " & "YTD" & " " & "is" & " " & [Text14]-[Text12] & " " & "more
compared to this time last year",[vendor Name] & " " & "spend" & " " &
[Month] & " " & "YTD" & " " & "is" & " " & [Text12]-[Text14] & " " &
"less compared to this time last year")

And it shows the results below:

Fallon London Ltd spend July YTD is 1904570 more compared to this time
last year.


How can I change 1904570 to the currency/decimal places format? This
was derived from the[Text14]-[Text12] fields.

Use a formatting function"

.... & " " & FormatCurrency([Text14]-[Text12]) & " " & ...
or
.... & " " & Format([Text14]-[Text12],"Currency") & " " & ...