Formatting currency in mail merge with Access data source

[Sam92Legacy]

When I merge a currency field into a WordXP doc from AccessXP, I lose the default currecy formatting ($x,xxx). I changed the column to the exrpression:

Amount: FormatCurrency([Pledge]![Amount],0,-1,0,-1)

However, when I tried to open my Word doc it could not locate the query. This problem does not happen when I omit the FormatCurrency expression.

As a workaround, I tried to format the field within the Word doc by using {MERGEFIELD Amount \$#,###). Unfortunately, this leaves a space between the dollar sign and the first digit of a number less than 1,000. Is there a different place holder that I can use or some way to get Word to work with the FormatCurrency expression?

Thanks,

Sam

 

[Sam92Legacy]

Please disregard. I just figured out that \# $,### works.