Mail merge

  PEG007 19:53 30 Jan 2007
Locked

When merging data from an Access dataset, times print as "long time" and not as the "short time" as formatted in the Access database eg 10:30AM merges as 10:30:00AM.
How do I get "short time" in the Word merge document?

  lotvic 23:44 30 Jan 2007

On this page click here

it says to do this:
"Use the Format function to control how the time is formatted. In your code,
surround the variable that contains the time value with this (assuming the
variable is called varTime):

Format(varTime, "hh:nn am/pm") "

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

iMac Pro review

Illustrator Charles Williams on how to create magazines and book covers

iMac Pro review

Les meilleures prises CPL (2018)