Reply
 
Thread Tools Display Modes
  #1   Report Post  
farley
 
Posts: n/a
Default long date formatting in access shows as short date in word

when merging fields from access to word, the long date formatting shows in
the letter as a short date.
  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

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" wrote in message
...
when merging fields from access to word, the long date formatting shows in
the letter as a short date.



  #3   Report Post  
farley
 
Posts: n/a
Default

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" wrote:

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" wrote in message
...
when merging fields from access to word, the long date formatting shows in
the letter as a short date.




  #4   Report Post  
Doug Robbins
 
Posts: n/a
Default

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
"farley" wrote in message
...
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" wrote:

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" wrote in message
...
when merging fields from access to word, the long date formatting shows
in
the letter as a short date.






Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
formatting numeric data from Access merged into a Word table LacieMoon Mailmerge 11 December 5th 06 10:12 PM
How do I control date formatting in a Word Mail Merge? Ric McWaters Mailmerge 1 April 21st 05 04:23 PM
Date mail merge field shows as serial Hiking Mailmerge 5 March 18th 05 10:25 AM
Date formatting in text form field, part II Ray_Johnson Microsoft Word Help 2 February 10th 05 10:01 PM
empty date fields in access Alan Mailmerge 4 January 13th 05 12:57 AM


All times are GMT +1. The time now is 12:01 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"