[Chris]

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