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.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

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

These are the Best Christmas Ads and Studio Projects of 2016

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…