Date Problem using mail merge.

[bajanboost]

I have specified in my Access database that I want my date format t
be a medium date with the following layout

19-Mar-0

This would display fine and to the exact format in Access, but when
pull it into a mail merge in Word, the format changes to: 3/19/0

Is there anyway that I can make it display like 19-Mar-04?

Another problem I am having in access is I have a field called "Mus
Use By:" where a user must manually enter a date on an item. The dat
can be any time from now or till 2 years in advanced, How do I mak
that field so that a user can manually enter that date easily? Not b
having to type 16-Mar-04. I would like an easier approach.
Thank You

 

[Jezebel]

You need to appreciate the difference between dates and date formats. A date
within an Access table (or indeed, any date variable) has no format. It is
actually a double in disguise. The format is applied only when the date is
displayed. So the format you specify within Access is irrelevant to the
display of the date in Word. To control the format in your mail merge,
either put a format instruction into the SQL statement ( ... select
Format([Use By], "d-MMM-yy") as UseBy_Date ... ) or add a format switch to
the field in Word.

Don't understand your second question.