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

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 (E-Mail Removed)> wrote in message
news:4A106493-CA12-41A6-86B3-(E-Mail Removed)...
> 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
>