Currency Format to Word Document

[Guest]

I am populating a word document with the result of a Dsum function in VBA.
I want it to appear in the Word document in Currency number format, or at
least with (2) numbers after the decimal point.

I have declared the variable as Currency
I have tried using FormatNumber([Refund,2) and FormatCurrency([Refund],2)
and neither works. It comes out accurately, but as an integer only if there
are no decimals. If there are decimals, they appear, but $1420.50 appears as
1420.5.

Any suggestions?

Thanks is advance.

 

[Rob Oldfield]

Try using the Format function instead.