I have a lot of date/time fields in a public folder and its corresponding
form, formatted as "9/22/2006" or "8:24 AM" depending on their application
and user preference. These formats hold within the form, but if I populate a
Word doc's bookmarks using UserProperties, they are all formatted as
"9/22/2006 8:24:00 AM" which makes a big ugly mess.

I can use FormatDateTime( ) on the UserProperties, but it does not offer a
good solution for time. vbShortTime format is military time. vbLongTime
includes the seconds, which I don't want either.

It would seem I'm faced with these choices:

Pull the display values from the form controls instead of the
UserProperties.
Doing string manipulation on the UserProperties to obtain time strings like
"8:24 AM"
Redo the Word template with Form fields formatted as desired (would this
even work?) .

Are there other simpler approaches?

Thanks,

Bill Le May