[Chris]

Sorry Peter,

I made a second typo, but that said it is still not working. I am going to
try this for a while longer and respond if I still can't get it to go.
Thanks for the input anyway.

Cheers, Chris

"Peter Jamieson" wrote:


Sorry for the lateness of the reply but it seems the postings were
not being
listed until just now.

FWIW the responses to your previous posts were visible here not long
after they were posted, but precisely what has gone wrong I cannot tell.

The ommission of the \* was a typo on my part in the original posting
- it
was not ommitted in the Word file. My apologies.

Lets' assume you actually had a \#, and you meant \# :-)

I did in fact also format the
field in the Access file as Currency (2 decimal places)

More likely the problem results from the use of a "Currency" type -
there are some known problems in this area and converting your currency
tpe to something else may well help, which is probably why Doug said:

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.

Peter Jamieson

http://tips.pjmsn.me.uk

On 11/01/2010 19:42, Chris wrote:
Hello Doug,

Sorry for the lateness of the reply but it seems the postings were not being
listed until just now.

The ommission of the \* was a typo on my part in the original posting - it
was not ommitted in the Word file. My apologies. Changing the Field switch
and updating always resulted in an error. I did in fact also format the
field in the Access file as Currency (2 decimal places), but that had no
effect either. Because it was not working I ended up saving the Word file
and the Access files in 2003 formats. This did work.

I am beginning to think that there are some issues here that need to be
sorted out my Microsoft.

"Doug Robbins - Word MVP" wrote:

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

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


.

.