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.

 

[blindmouses]

Hello Wayne.... )))))

Thank you ever so much for that brilliant idea to change date format into text. We have tried soooo many options to adjust date from access in word's mail merge, but it has always bring us to the new problem....

Thank you again

Take care