Merged Time Formats in work from access

[Alistair]

When I try to merge a time field (11am) into word it is diplayed as 1899-12-30 11:00:00 and not 11am as I would like. I have tried inserting the switch \@ "hh:mm am/pm" into the toggled field code but this make no differance. can anyone explain what is wrong and how to fix this apparent bug?

 

[Graham Mayor]

Is this Word 2002/3?
See the Excel data section of
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm, for which purpose
Access and Excel can be considered on the same basis.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>