Access only supplies the values of the Date Field (unless you use the
Format() function in a Calculated Field "DateText" in the Query you want to
use as the DataSource for the MailMerge).
Using Word, set the correct date format for the required MergeField and Word
will pick up the date values from Access and format them the way you want.
--
HTH
Van T. Dinh
MVP (Access)
"Niddala100" wrote in message
...
I am having trouble with a Word mail merge using Access as my data source.
I
have Access set up to have dates in "long date" and time in "medium
time".
When I merge to Word the fields show in "short date" and "long time". How
do
I fix this? I want the Word document to read Thursday, September 9, 2004
and
the time to read 4:00 PM and so forth. It now reads as 9/9/04 and
4:00:00.
|