Mail merge from Access D/B changes date to USA format

[wjoc1]

Lads,

Here's a little problem that is driving me nuts. I know what is wrong and yet I can't fix it!

I have an Access D/B and a mail merge word doc which gets its data from a table in the database. Now the date is in the correct format in the table i.e. uk/european format. The 5 of january 2005 would be 05/01/2005.

However when this gets into the word doc it changes to USA format i.e. 01/05/2005.

Not very desireable! how do I fix it?

Thanks in advance,
Liam

 

[RuralGuy]

Have a look/see here:

http://www.mvps.org/access/datetime/date0005.htm
Date/Time: Return Dates in US #mm/dd/yyyy# format

 

[wjoc1]

I've often had this problem with Access D/B's before and I have used the format function to correct them. However this time the date is reverting to the US format outside in the word doc. where I cannot apply something like the format function. This is where I'm getting stuck!

Liam

 

[neileg]

But you can apply formatting to a merge field in Word!

 

[b_karv]

1. Get Latest updates of MS Office & Access ( see below)
2. Make sure all date formats in Access DB is set to medium date
3. Apply the formatting function in Word eg
{MERGEFIELD "dates" \@ "d MMMM, yyyy" }

where dates it the merging field...........


These are the latest update filenames off microsoft's website:

MDAC_TYP.exe
officexp-kb833857-client-enu.exe
OfficeXpSp3-kb832671-fullfile-enu.exe
WindowsServer2003-KB829558-x86-ENU.exe
windowsxp-kb829558-x86-enu.exe