It may depend on the precise version of Word, but you can try
a. add a "format switch" to each date MERGEFIELD field in Word. e.g. use
Alt-F9 to view the fields, in the mail merge main document, then change
{ MERGEFIELD mydate }
to
{ MERGEFIELD mydate \[ at ]"DD/MM/YYYY" }
Test with ambiguous dates, i.e. where the day number is 1 to 12.
b. if you are using Word XP/2003, change back to the old DDE connection
method (check Word Tools|Options|General|Confirm conversion at open, then go
through the connection process again. Word has to start Access if it's not
already going, you lose non-ANSI characters in text fields, and thetreatment
of other field types, particularly memo fields, may be different.
Peter Jamieosn
"mixers" <mixers[ at ]discussions.microsoft.com> wrote in message
news:5F4354E8-5ACB-4894-8BFD-F3A848E5B4D4[ at ]microsoft.com...
[Quoted Text] > When mail merging a word document through an Access database, the date
> format
> field changes from UK to US. How do I prevent this?
|