I have a access database with all dates in UK format. When I link a word document to a query in access and do a Mail Merge all the dates change to American format.

I am baffled

When you select the merge field in Word ensure that you select the correct format, ie, dd/mm/yyyy

If your dates are in tables and the columns are defined as date/time datatypes, they do not have a specific format until you apply one. Dates are NOT stored as strings. We display them as strings because that's how humans want to see them. To pass the date in the correct format to an external application, use the Format() function in the query to specifically turn the date into a string formated as you want to see it.

Select ....., Format(YourDate, "dd/mm/yyyy") As FormattedDate
From YourTable
Order by SomeField;

Thanks
I did what you suggest but it does not work.
In the query No problem but in word still same USA Date Style.

Post your query please.