Mail Merge Is Reversing My Dates

Hi I am running an Access program on a network. It's function is to grab some data including a Date and then mail merge it to a word template letter.

The 3 Computers are running WinXP with Word 2001 with Access 2001.

What is happening is that on 2 computers when a mailmerge is done they are displaying the date as reversed ie 9th Decemeber 2004 as 12th September 2004....I live in Australia so we support dd/mm/yy.

On the other computers it works fine.

Now interestingly if I change the data type in the table where the data is being grabbed from to a Text type instead of a Date type, the date is displayed corectly on the two computers that it wasn't working on before and incorrectly on the computer it was working on initially.


On all computers the regional settings are set to Australia.

Also within the word document I am formatting the dates to a long date in the toggle field code section ie;
{MERGEFIELD "DD" @ "d mmmm, yyyy"}


Any help suggestion will be very welcome as it is vital for me to run my program on all computers via network

Thankyou in advance