Date format in access to word mail merge

[vand_uk]

In doing a mail merge from access to word, all seems fine, except that the date format is incorrect. On the form in access it shows as dd/mm/yyyy correct for UK. However checking thro the mail merge doc it has swapped over to mm/dd/yyyy, american version. Can anyone help me with this??

 

[charityg]

The only way I can figure out how to maintain any type of formatting of a date field when merging to a Word doc, is to create a query that converts the date to a string with the correct format.

Example:

Select *, Format(MyDate,"d/m/yyyy") as FormatDate from myTable

and then use the query as the datasource for the merge.