Date/Time field different format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lauren - 07 May 2004 12:49 GMT

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

Reply to this Message

Peter Jamieson - 07 May 2004 16:14 GMT

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" }

Signature

Peter Jamieson

> Hi all,
>
[quoted text clipped - 15 lines]
> Thanks,
> Lauren

Reply to this Message

Cindy M -WordMVP- - 07 May 2004 16:49 GMT

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
[quoted text clipped - 4 lines]
> 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

:-)

Reply to this Message

- 07 May 2004 19:44 GMT

Thanks! I'll take a look.

Lauren

>-----Original Message-----
>Hi Lauren,
[quoted text clipped - 26 lines]
>
>.

Reply to this Message

- 07 May 2004 19:45 GMT

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

Lauren

>-----Original Message-----
>Hi Lauren,
[quoted text clipped - 26 lines]
>
>.

Reply to this Message