US date format

M

Migi2z

I have set up a mailmerge Word document based on an Access query. In the
query the date is in UK format (dd/mm/yyy) but once the query is merged with
the Word document it displays all dates in US format (mm/dd/yyy). Although I
have changed all underlying date formats i.e. in the tables that the query is
based on, I cannot get the dates to display correctly in the Word document.
Please can you help me?
 
M

Migi2z

My apologies Anne, it does work but it was necessary to close the document
first for the changes to take effect. Many thanks for your help. It is very
much appreciated.

Regards
Migi2z
 
A

Anne Troy

You'll always need to update the fields to see the changes. Fields can be
updated by closing and opening the file, doing a print preview, printing, or
hitting Ctrl+A and F9. :) I'm going to add this information to the article.
I'm glad you pointed it out.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - exporting serial letters to single documents 0
Date Formats 4
How to add day to PWA 2016 date format? 0
Forcing a date entry format of dd/mm/yyyy 1
formatting date mergefield in format "19-01-2008", not "1/19/2008" 1
Mail merge Dates puzzler 3
Change US date to UK date in mail merge 1
The date in a merged word doc is US format source is UK format 4

Top