Sorry for not clarifying the issue, I had an update from my client. They are
using Mail Merge Recipient button, find "in this field" - a date field.
Although the dates appear in UK form in the column, they have to type the US
version for it to find records containing the correct dates.
--
Thanks for replying so quick.
______
"Peter Jamieson" wrote:
when I run a query the
date still has to be entered in US format
Do you mean that
a. you are connecting to an Access parameter query, and the users are
typing a date into the box that Access pops up? or
b. they are specifying out query options in Word's Mail Merge Recipients
dialog box, or the query options dialog box? or
c. something else?
(And which version of Word/Access?)
(I'm not sure it makes any difference whether it's (a) or (b) but it would
be helpful to know for the purposes of investigation)
--
Peter Jamieson
http://tips.pjmsn.me.uk
"Big Mac" wrote in message
...
Mailmerge to Access brings US date format but I have got the format
showing
In UK format in Word using the field switch however when I run a query the
date still has to be entered in US format. Is there any way to change this
so
that my clients can enter the date in UK dd/MM/yyyy format
--
Thanks in advance for your time