Date/Time field different format

[Lauren]

Hi all,

I am trying to do a mail merge letter in Word using an MS
Access table as my data source. I have formatted the
date/time fields in my Access table as "Medium time" so
that I only see the hours and the minutes in my field.
When I view the table, everything looks fine but when I
insert those fields into my letter, the format of the
field within Word includes the seconds. It's driving me
crazy. Has anyone else experienced this? I have tried this
on two different computers and in Word 2002 and Word 2003,
both on Windows XP machines. Always the outcome is the
same.

If anyone has some insite on this, I would greatly
appreciate it.

Thanks,
Lauren

 

[Peter Jamieson]

Typically, Word retrieves the underlying format (including the seconds). You
should be able to use a format switch in your MERGEFIELD field in Word, e.g.
use Alt-F9 to reveal the field codes and change

{ MERGEFIELD mytime }

to

{ MERGEFIELD mytime \@"hh:mm" }

 

[Cindy M -WordMVP-]

Hi Lauren,

I am trying to do a mail merge letter in Word using an MS
Access table as my data source. I have formatted the
date/time fields in my Access table as "Medium time" so
that I only see the hours and the minutes in my field.
When I view the table, everything looks fine but when I
insert those fields into my letter, the format of the
field within Word includes the seconds. It's driving me
crazy. Has anyone else experienced this?

This is normal for Word 2002/2003, and it's due to the
default connection method.

For more information on this, plus what you can do to see
what you prefer, check out the information in the Word 2002
section of my website's mail merge FAQ.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
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

 

[Guest]

Thanks! I'll take a look.

Lauren

-----Original Message-----
Hi Lauren,

This is normal for Word 2002/2003, and it's due to the
default connection method.

For more information on this, plus what you can do to see
what you prefer, check out the information in the Word 2002
section of my website's mail merge FAQ.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep
30 2003)
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


.

 

[Guest]

Thanks for the advice. I was about to try this but wasn't
sure how to write the expression. I appreciate the help!

Lauren