long date formatting in access shows as short date in word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

farley - 15 Aug 2005 16:59 GMT

when merging fields from access to word, the long date formatting shows in
the letter as a short date.

Reply to this Message

Doug Robbins - 15 Aug 2005 20:42 GMT

See "Formatting Word fields with
switches" on fellow MVP Graham Mayor's website at:

http://www.gmayor.com/formatting_word_fields.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> when merging fields from access to word, the long date formatting shows in
> the letter as a short date.

Reply to this Message

farley - 16 Aug 2005 02:12 GMT

Doug,
You are truly the savior for the day. I've been pulling my hair out (not a
good thing to do considering its population) trying to get around this
formatting thing. I never would have gotten the "reverse formatting" on my
own. Seems to me that it would have been easier to leave the formatting
responsibilities with the origional program and to have Word just accept it.
. . oh well, better minds than ours . . . .
Thanks again,
Tug

> See "Formatting Word fields with
> switches" on fellow MVP Graham Mayor's website at:
[quoted text clipped - 3 lines]
> > when merging fields from access to word, the long date formatting shows in
> > the letter as a short date.

Reply to this Message

Doug Robbins - 16 Aug 2005 04:45 GMT

Access does not store the dates in the format that it displays them.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Doug,
> You are truly the savior for the day. I've been pulling my hair out (not a
[quoted text clipped - 15 lines]
>> > in
>> > the letter as a short date.

Reply to this Message