Mail merge access and MS Word

[Guest]

Since upgrading to office 2003, whenever I mail merge to msword the date
format transposes to US English ie. 1/31/05 instead 31/01/05. I have altered
all my settings in both access and word and also my PC settings all to no
avail. Any ideas?

 

[David Lloyd]

Claire:

I am not sure if this KB article addresses your issue, however, I thought I
would make you aware of it. The article demonstrates a method for
formatting mail merge dates in Word.

http://support.microsoft.com/default.aspx?scid=kb;en-us;304387

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Since upgrading to office 2003, whenever I mail merge to msword the date
format transposes to US English ie. 1/31/05 instead 31/01/05. I have
altered
all my settings in both access and word and also my PC settings all to no
avail. Any ideas?

 

[Guest]

Hi Claire

I had the same problem - you need to add Switches to the field something
like {MERGEFIELD MYDATE\@ "dd-MM-yy"} Right mouse click on the field and
choose Toggle Field Codes then put Switch after the Field Name but inside the
brackets - something like {MERGEFIELD MYDATE\@ "dd-mm-yy"}

Sheila

 

[Guest]

Hi Claire I too had the same problem and solved it by addng and unbound
txtbox to the form and on lost focus of the date copied the date into the
unbound form. Using this as the link with word seems to work.
Bob Fortune