date format changing in mail merge

M

mixers

When mail merging a word document through an Access database, the date format
field changes from UK to US. How do I prevent this?
 
P

Peter Jamieson

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 \@"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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top