Mailmerge date persists in showing the time.

[jhowley58]

I'm using automation to initiate mailmerge from Access. I use the short form for date. Trouble is when I fire up the word document from Access, and that document gets the date from an access table, it always displays(prints) it in Date and time form. How can I get it to drop the time part?

Thanks .

John

 

[votegop]

It sure sounds like the difference between Now() and Date() in your code.

 

[3587]

If votgop's idea does not work try using
Format([Date],"mm/dd/yyyy&quot or FormatDateTime(Date,2)