Time shows up in mail merge date field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

UK dates in database appearing as US dates in a mail merge document 2
Merged data, access to word, adds the time in date field 1
Access 2007 Date field shows Now instead of Date 4
Mail merge 5
Datepicker issue after changing Windows' short date time format 5
date format reversed when merged into word 1
Word mail merge using Access. Formatting wrong. 3
UK date format in Mail Merge letters 4

Back
Top