US date format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Migi2z - 04 Jul 2005 11:43 GMT

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?

Reply to this Message

Anne Troy - 04 Jul 2005 15:35 GMT

This should help:
http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

> 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?

Reply to this Message

Migi2z - 04 Jul 2005 16:07 GMT

Sorry, Anne, but it doesn't work. The formatting remains the same.
Migi2Z

> This should help:
> http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm
[quoted text clipped - 14 lines]
> document.
> > Please can you help me?

Reply to this Message

Migi2z - 04 Jul 2005 16:24 GMT

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

> Sorry, Anne, but it doesn't work. The formatting remains the same.
> Migi2Z
[quoted text clipped - 17 lines]
> > document.
> > > Please can you help me?

Reply to this Message

Anne Troy - 04 Jul 2005 16:29 GMT

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

> 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
[quoted text clipped - 7 lines]
> >
> > > This should help:

http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm

> > > *******************
> > > ~Anne Troy
[quoted text clipped - 12 lines]
> > > document.
> > > > Please can you help me?

Reply to this Message

Rate this thread: