Mail merge

  PEG007 19:53 30 Jan 07
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 07

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.

Intel Coffee Lake 8th-gen Core processors release date rumours

1995-2015: How technology has changed the world in 20 years

Framestore’s haunting post-WWII title sequence for new BBC series SS-GB

Best iPhone games 2017 | Best iPad games 2017: 162 fantastic iOS games that you need to play right…