How to change date format when using Word Mailmerge

G

GillJ

I have been trying to set up a mailmerge using data contained in an Access
database. One of the fields is DOB. I have formatted this field in the
database dd/mm/yyyy. However, when trying to merge the data, this field
appears in Word as mm/dd/yyyy. I've tried without luck to change the format.
Does anybody know how to achieve this?
 
J

John W. Vinson

I have been trying to set up a mailmerge using data contained in an Access
database. One of the fields is DOB. I have formatted this field in the
database dd/mm/yyyy. However, when trying to merge the data, this field
appears in Word as mm/dd/yyyy. I've tried without luck to change the format.
Does anybody know how to achieve this?

Base the merge on a Query with a calculated field:

ShowDOB: Format([dob], "dd/mm/yyyy")

This will explicitly cast it as a string, and Word won't see it as a date/time
and therefore apply its own formatting.
 
L

Larry Daugherty

You could change your System settings but that's probably not a good
thing to do. Date fields in all applications would be affected.

The solution may lie in Word. It's been a long time since I meddled
with anything but plain vanilla merges but it seems that I used to be
able to perform operation on field data in Word. It should be
possible to use Format() to display the date as you wish.

HTH
 

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

Top