Date format - change when merged to Word

[CW]

In all our forms we like to use the date format --/--/---- e.g. 09/06/2006.
However in merged letters to customers we would prefer to have the date
shown as September 6, 2006.
Is it possible to do this: change the format from the way it is held at
source in Access, into a different format when it comes out in Word?
Thanks
CW

 

[Van T. Dinh]

2 methods:

1. Pass the date value to Word and set the Format in the MergeField in the
Word MailMerge document.

Check Word Help on MergeField and different MergeFormats you can use.

2. Create a Calculated Field

MergeDate: Format([YourDate], "mmmm\ d\,\ yyyy")

and use the Query with the above Calculated Field as the DataSource for your
MailMerge document.