Date format doesnt match from MsAccess
in [Document Management]
|
Prev: Word 2003: direction set by cursor is reversed. How do I reset?
Next: Convert Doc to PDF keeping hyperlinks & table of contents
From: Don Durai Don on 27 May 2010 22:27 Hi, I have a database in Access which i store employee details. And i will merge it with Word to print the offer letter. The problem is in the recruitment date column. The date format in Access is Medium Date(28-May-10) and when its merged in Word it comes out as m/dd/yyyy(5/28/2010). Please help. Thanks
From: Suzanne S. Barnhill on 27 May 2010 22:41
You need to add a numeric picture switch to your merge field. See http://www.gmayor.com/formatting_word_fields.htm -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Don Durai" <Don Durai(a)discussions.microsoft.com> wrote in message news:4A106493-CA12-41A6-86B3-DF4F9473A1BE(a)microsoft.com... > Hi, > > I have a database in Access which i store employee details. And i will > merge > it with Word to print the offer letter. The problem is in the recruitment > date column. The date format in Access is Medium Date(28-May-10) and when > its > merged in Word it comes out as m/dd/yyyy(5/28/2010). Please help. > > Thanks > |