Mailmerge using Word and Access 2003

C

Chester1

Please can anyone tell me why when I do a mailmerge using an access 2003
database any Date fileds are entered using American Dates even though all the
dates in the database are english???
 
T

Tom Wickerath

Hi Clair,

Try adding a Format statement to the date field in your query. For example:

Field: FormattedDate: Format([OrderDate],"d mmm yyyy")

Substitute OrderDate with the name of your date field.

Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

Please can anyone tell me why when I do a mailmerge using an access 2003
database any Date fileds are entered using American Dates even though all the
dates in the database are english???
 
V

Van T. Dinh

Another alternative is to set the apprpriate date format for the MergeFields
in the MailMerge document.
 
B

Bob Fortune

The reason is that on merging the date format is not transferred. A solution
is to right click the mergefield in word, and click toggle field and enter
after MERGEFILD YOURDATELINK \@"dd-MM-yyyy" Should look something like this
{MERGEFIELD DATE \@ "dd-MM-yyyy"} Hope this is some help
 
Top