long date formatting in access shows as short date in word

[farley]

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

 

[Doug Robbins]

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

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



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

 

[farley]

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

 

[Doug Robbins]

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

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