[Cogito]

Macropod

Thank you for your reply. This solution worked. I am suprised that on a UK
spec pc. Is there a permanent fix?

Regards

"macropod" wrote:

Hi Cogito,

You can fix this by adding a switch to the mergefield. To do this:
.. select the field and press Shift-F9. You should see something like {MERGEFIELD dbDate}
.. change this to {MERGEFIELD dbDate \@ DD/MM/YYYY}
.. press F9 to update the field
.. run your mailmerge

For more information on field formatting, see Word's help file

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

"Cogito" wrote in message ...
I have created an access database with date fields in the UK format
dd/mm/yyyy. When I merge this data into a word document the date field is
shown in the US format mm/dd/yyyy. The regional settings are for the UK.

Please advise a solution.

Thank you