Hi.
Ive started to investigate the merging of date and time fields from Access97
to Word 97 and Im getting a strange result when I try to set up a field
Switch. Im sure the solution is simple.
Word Help says the following when describing the format for a typical Switch
in a Time field:
{ TIME \@ "h am/pm" } displays "9 am" or "5 pm"
In my case Im using the following and the actual field value is 01.40:
{ Start_Time \@ "hh:mm am/pm" }
When I view the merged result I get:
01:40 a40/p40
It seems that the letter m in the am/pm statement is getting interpreted as
minute.
What am I doing wrong? Thanks, JohnB
Hi JohnB,
This is just off the top of my head, but I believe you can't use double hh.mm
when am/pm.
> Word Help says the following when describing the format for a typical Switch
> in a Time field:
[quoted text clipped - 11 lines]
> It seems that the letter m in the am/pm statement is getting interpreted as
> minute.
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)
JohnB - 14 Jun 2005 10:45 GMT
Thanks for this Cindy.
It sounds like you could have the answer. Ill investigate further and will
get back to you on this thread, within 24 hours, if I still have problems.
Thanks again, JohnB
> Hi JohnB,
>
[quoted text clipped - 24 lines]
> This reply is posted in the Newsgroup; please post any follow question or
> reply in the newsgroup and not by e-mail :-)
JohnB - 14 Jun 2005 17:23 GMT
Hi again Cindy.
Just discovered that this works OK if you go into Regional Settings and set
the default time format to twelve hour clock. Your suggestion didnt work Im
afraid.
Cheers, JohnB
Cindy M -WordMVP- <C.Meister-C@hispeed.ch> wrote in message
news:VA.0000afc0.007e028b@speedy...
> Hi JohnB,
>
[quoted text clipped - 24 lines]
> This reply is posted in the Newsgroup; please post any follow question or
> reply in the newsgroup and not by e-mail :-)
Cindy M -WordMVP- - 15 Jun 2005 11:14 GMT
Hi JohnB,
> this works OK if you go into Regional Settings and set
> the default time format to twelve hour clock.
Well, yes. I had assumed this was what you had, already :-)
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Jun 8 2004)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)