You have omitted the \#
You should be using { MERGEFIELD ColFee \# "$,#.00;($,#.00" }
Note however, if you are using the Format() function in a query in Access to
format the currency to the way that you want it, that will convert it to
text and no further formatting will be required in Word.
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
"Chris" wrote in message
...
Hello,
I have been trying to insert the merge field switches to control the
appearance of data merged from Access 2007.
I am merging from an Access dbase query and I converted the fields in
Access
to Currency and 2 decimal places there first.
I went into the the Word 2007 options and turned on "Confirm file format
conversion on open". In the Confirm Data Source dialogue box I am
selecting
MS Access Databases via DDE (*.mdb;*.mde). There is often a problem with
this little procedure as well, but that is for a different day.
I am inserting the field switches as indicated on Graham Mayor's website
at
http://www.gmayor.com/formatting_word_fields.htm
When I toggle the field code in Word this is what I am using:
{ MERGEFIELD ColFee "$,#.00;($,#.00" }
I have tried other methods as well but nothing seems to work.
Any help with this would be greatly appreciated. Thanks,
Chris