Hi Everyone,

I don't know if this is the correct forum but I thought i'd ask. I have an
access DB with a function to automatically safe a table with fields i'm mail
merging into MS Word. Word looks at the table from the Access Database.

The export function all works, but the Date format is incorrect. I want it
in Long format (Tuesday, 2, May, 2006) which is how it's stored in the
table. When I open Word with the merged document, the date is in Short and
the format is American. 5/2/06. I want it to show as long format above.

Can someone help me with where I can change the formatting?

Thanks.