How do I stop a date changing to American format in mail merge

[Mrs Bulldog]

I am using an Access database to produce a mail merge in Word. When the data
is pulled through the date changes from UK version ie., 26/08/1997 to
08/26/1997. Does anyone know how to rectify this?

 

[Wayne-I-M]

There are a few work-arounds
You could use word - not access - to provide the date
You can format the date as text before your merge
etc

 

[John W. Vinson]

On Mon, 2 Mar 2009 06:38:11 -0800, Mrs Bulldog <Mrs

I am using an Access database to produce a mail merge in Word. When the data
is pulled through the date changes from UK version ie., 26/08/1997 to
08/26/1997. Does anyone know how to rectify this?

Rather than mailmerging from the Table - which will indeed ignore any format
you have specified - create a Query based on the table; include a calculated
field

ExpDate: Format([datefield], "dd/mm/yyyy")

to explicitly cast the date into UK form. Mail merge from this Query rather
than from the table.