Format currency within string expression

[wilpeter]

Report has a conditional expression with IIF that produces a string result when record value of currency field is not zero; and I want the string to say "Amount of Donation is $29.50" for a $29.50 value and be blank for a $0.00 value. I have =IIf([Don4]0," ","Amount of Donation is "&[Don4]
which presently produces "Amount of Donation is 29.5" Any suggestion as to inserting format currency to that portion of logic? Thanks.

 

[Kiwiman]

How about

Amount of Donation is "& format([Don4],"Currrency")

 

[vbaInet]

Slight amendment:

"Amount of Donation is " & format([Don4], [COLOR=Red]"[/COLOR]Currrency[COLOR=Red]"[/COLOR])

 

[wilpeter]

Thanks for quick response; however, the word Currency is auto-adjusted to [Currency] within string. Any way to avoid it?

 

[Kiwiman]

Howzit

Put quote marks around currency - my mistake on original post

 

[wilpeter]

OK, now I see your revision "currency" - yes, it works fine. Have a great day!

 

[wilpeter]

By the way, I used to summer (as a kid) at Weston-Super-Mare. Cheers!

 

[vbaInet]

By the way, I used to summer (as a kid) at Weston-Super-Mare. Cheers!

I bet you like it and wish to return.