date format reversed when merged into word

A

Adam

I have created a database which has a macro that merges an enquiry into word.
All the merge fields work, however the date has been reversed and I can not
find out how to change this

Please help
 
D

Douglas J. Steele

In your query, use the Format function (not the Format property) to format
your date however you want it to appear.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

UK dates in database appearing as US dates in a mail merge document 2
Merge from Access to Word - Loses Data Source 2
Access to Microsoft Word Merge (simple math) 5
Can I tell whether Access was opened by Word? 7
Trouble with some mail merges between MS Access & Word 2
Albert Kallal 3
mailmerg current record from a Access form to Word 1
Calling Alber Kallal on Easy Word Merge!!!! 8

Top