Home |
Search |
Today's Posts |
#1
|
|||
|
|||
date format change when using serial printing
Hi,
When I use serial printing, one of the field is a date. This date is in the following format, dd-mm-yyyy in the database (access 2000) but when I open the word doc whit the serial printing, the fild with the date is in mm-dd-yyyy format. Where/How can I solve this problem. Thanks, Paulo Meireles |
#2
|
|||
|
|||
You can either use a Picture switch on the merge field, such as /@
"dd-MM-yyyy" (note the capitalization) or use an alternate method to connect to the data source. In Word go to Tools/Options/General and turn on "Confirm conversion at open". Then select your database as the data source again. When prompted select the DDE method. -- Please post all follow-up questions to the newsgroup. Requests for assistance by email can not be acknowledged. ~~~~~~~~~~~~~~~ Beth Melton Microsoft Office MVP Word FAQ: http://mvps.org/word TechTrax eZine: http://mousetrax.com/techtrax/ MVP FAQ site: http://mvps.org/ "Paulo Merieles" wrote in message ... Hi, When I use serial printing, one of the field is a date. This date is in the following format, dd-mm-yyyy in the database (access 2000) but when I open the word doc whit the serial printing, the fild with the date is in mm-dd-yyyy format. Where/How can I solve this problem. Thanks, Paulo Meireles |
#3
|
|||
|
|||
You have your slash facing the wrong way - if you'll pardon the expression
\@ "dd-MM-yyyy" -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Beth Melton wrote: You can either use a Picture switch on the merge field, such as /@ "dd-MM-yyyy" (note the capitalization) or use an alternate method to connect to the data source. In Word go to Tools/Options/General and turn on "Confirm conversion at open". Then select your database as the data source again. When prompted select the DDE method. "Paulo Merieles" wrote in message ... Hi, When I use serial printing, one of the field is a date. This date is in the following format, dd-mm-yyyy in the database (access 2000) but when I open the word doc whit the serial printing, the fild with the date is in mm-dd-yyyy format. Where/How can I solve this problem. Thanks, Paulo Meireles |
#4
|
|||
|
|||
lolol Thanks for the correction. :-)
-- Please post all follow-up questions to the newsgroup. Requests for assistance by email can not be acknowledged. ~~~~~~~~~~~~~~~ Beth Melton Microsoft Office MVP Word FAQ: http://mvps.org/word TechTrax eZine: http://mousetrax.com/techtrax/ MVP FAQ site: http://mvps.org/ "Graham Mayor" wrote in message ... You have your slash facing the wrong way - if you'll pardon the expression \@ "dd-MM-yyyy" |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I change the format of my document so that I can make cha. | Microsoft Word Help | |||
Why does the original date change upon opening a document? | Microsoft Word Help | |||
How do you change the format of the track changes feature? | Microsoft Word Help | |||
Mail Merge - Date Format | Microsoft Word Help | |||
Date Format | Microsoft Word Help |