Formatting "Currency" in VB module

[kjclark]

How do you get rid of the decimal places when using the "Currency" format?

Here is the line:
lbldifferenceAR.Caption = Format$([SumOfSumOfAR] - LastAR, "Currency&quot

But since it's standard formatting, I get the 0.00 decimals when I want the rounded number without decimals. I tried the ($#,###), but then I loose my parenthesis around negative numbers.

Any suggestions?

Thanks in advance for your help!
Karla

 

[combo]

Instead of Format Use FormatNumber function with appropriate arguments.

combo

 

[Chrisbi]

What about

lbldifferenceAR.Caption = FormatCurrency([SumOfSumOfAR] - LastAR, 2)

 

[kjclark]

Worked perfectly! Thanks for your help!