Time shows up in mail merge date field

A

AGMPreacher

For years I have been doing mail merge with the date of my meetings in the
body of the letter. All of a sudden it starts putting the time (always 12:00
AM) next to the date. I have checked to make sure the date field in table is
set to short date, and check the date field in form and queries. All seems
fine. Can anyone please help, I am way behine in my correspondence. I was
using Access 2002 with Word 97. I thought that might be the problem, so went
out and bought Word 2003. Didn't help. Thank you in advance.
 
V

Van T. Dinh

Either you set the proper date format in the MergeField in Word so that Word
only display date and not the (zero) time component or use a Calculated
Field in the source query using the Format() function to convert the date
value in Access to a variant of String type so that Word see it as Text.

Note that the Format "Short Date" in the Table doesn't help since the Format
Property only affects how the value is displayed in DatasheetView of the
Table. However, in MailMerge, Access only passes the *value* to Word, not
how the date is displayed / printed.
 
Top