Generally speaking if your format is always the same, it is better to format
the number in Word.
e.g. if your field is called myamount, and you want it to appear as
$9,123.00,
a. use Alt-F9 to show the field codes in your Word mail merge main
document. You should see something like
{ MERGEFIELD myamount }
If you see an additional "switch" saying \*Mergeformat, you can usually
delete it.
Then add a "numeric format switch" to the field so it looks like
{ MERGEFIELD myamount \*"$,0.00" }
NB, that should work even for larger amounts, i.e. the "," means "use a
thousands separator"
If you have other regional settings, e.g. you need £, or "." is set up as
the thousands separator in Control Panel-Regional Settings, use those.
Alternatively, you can usually see the formatting that you defined in Access
by changing the way that Word connects to Access to use the old DDE method.
However, I would avoid that unless it's really necessary.
--
Peter Jamieson
http://tips.pjmsn.me.uk
"Giles Ayling" Giles
wrote in message
...
I am loosing the currency format when I mailmereg from Access 2007 to Word
2007. Anything I can do?