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