Access to Word - Date format

[Bill Ezekiel]

I have data on an Access database. One of the fields is a
date and is entered on the database in dd/mm/yyyy format.
When merged into a Word document it is re-formatted into
mm/dd/yyyy format (i.e. from International to US format).
As far as I can figure, everything is set to English (UK)
so what am I doing wrong?

 

[Graham Mayor]

Word 2002/3?

See the Excel data section of
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm (the issue is the
same with Excel).

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

Hi Bill,

The surest way to overcome this problem is to use an Access Query as the
datasource and in that Query, use the Format([Datefield], "dd/mm/yyyy")
function to force the date into that format.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.
Hope this helps
Doug Robbins - Word MVP