| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Mail Merge - Word 2003 & Access 97
I am running Word 2003 & Access 97. For months I have had no problem w/ the
date of birth format (M,d,yyyy) coming from my Access database. However, for no reason I can ascertain, suddenly in my Word 2003 letter, the date of birth is showing and printing: yyyy-M-dd and also w/ the time 00:00:00. I have checked the regional system settings on the computer, as well as the date format in Access, and they are both formatted for the short date M,d,yyyy. Any suggestions other than leaving this item blank and writing or typing it in separately? -- betty |
|
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Mail Merge - Word 2003 & Access 97
Use a date switch on the field - see
http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org betty wrote: I am running Word 2003 & Access 97. For months I have had no problem w/ the date of birth format (M,d,yyyy) coming from my Access database. However, for no reason I can ascertain, suddenly in my Word 2003 letter, the date of birth is showing and printing: yyyy-M-dd and also w/ the time 00:00:00. I have checked the regional system settings on the computer, as well as the date format in Access, and they are both formatted for the short date M,d,yyyy. Any suggestions other than leaving this item blank and writing or typing it in separately? |
|
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Mail Merge - Word 2003 & Access 97
I tried. Perhaps I don't know where to place the date switch field. I found
your website did not sufficiently explain. Perhaps you could type a reply that I can copy into my document? -- betty "Graham Mayor" wrote: Use a date switch on the field - see http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org betty wrote: I am running Word 2003 & Access 97. For months I have had no problem w/ the date of birth format (M,d,yyyy) coming from my Access database. However, for no reason I can ascertain, suddenly in my Word 2003 letter, the date of birth is showing and printing: yyyy-M-dd and also w/ the time 00:00:00. I have checked the regional system settings on the computer, as well as the date format in Access, and they are both formatted for the short date M,d,yyyy. Any suggestions other than leaving this item blank and writing or typing it in separately? |
|
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Mail Merge - Word 2003 & Access 97
You add the date switch to your merge field.
-- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "betty" wrote in message news  I tried. Perhaps I don't know where to place the date switch field. I found your website did not sufficiently explain. Perhaps you could type a reply that I can copy into my document? -- betty "Graham Mayor" wrote: Use a date switch on the field - see http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org betty wrote: I am running Word 2003 & Access 97. For months I have had no problem w/ the date of birth format (M,d,yyyy) coming from my Access database. However, for no reason I can ascertain, suddenly in my Word 2003 letter, the date of birth is showing and printing: yyyy-M-dd and also w/ the time 00:00:00. I have checked the regional system settings on the computer, as well as the date format in Access, and they are both formatted for the short date M,d,yyyy. Any suggestions other than leaving this item blank and writing or typing it in separately? |
|
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
|
Mail Merge - Word 2003 & Access 97
All the information that you need to do this is on that web page; however
Press Alt+F9 toggle the display. It will show something like {Mergefield Fieldname} add the switch after the fieldname thus {Mergefield Fieldname \@ "M,d,yyyy"} Press F9 to update then ALT+F9 to toggle back again. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org betty wrote: I tried. Perhaps I don't know where to place the date switch field. I found your website did not sufficiently explain. Perhaps you could type a reply that I can copy into my document? Use a date switch on the field - see http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org betty wrote: I am running Word 2003 & Access 97. For months I have had no problem w/ the date of birth format (M,d,yyyy) coming from my Access database. However, for no reason I can ascertain, suddenly in my Word 2003 letter, the date of birth is showing and printing: yyyy-M-dd and also w/ the time 00:00:00. I have checked the regional system settings on the computer, as well as the date format in Access, and they are both formatted for the short date M,d,yyyy. Any suggestions other than leaving this item blank and writing or typing it in separately? |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| take yet another lesson from wordperfect "reveal codes" | Microsoft Word Help | |||
| mail merge with word 2003 | New Users | |||
| Word 2003, mail merge disabled when doc opened in Internet Explore | Mailmerge | |||
| mail merge - Access 2000 and Word 2000 | Mailmerge | |||
| Web-Site-based Word Mail Merge & Access DB | Mailmerge | |||
Linear Mode
