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

Fujitsu Lifebook P727 laptop review

Lightwell software lets you create mobile apps without using code

Best value Mac: Which is the best £1249 Mac to buy

Comment désactiver les programmes qui s'exécutent au démarrage de Windows 10 ?