Change date format display in mail merge document

chazer1

Registered User.
Local time
Today, 03:52
Joined
Sep 26, 2004
Messages
10
When mail merging from an Access 2000 database into Word 2000 date fields are shown as dd/mm/yy in the merged documents.

I would like them to display as mmm-yyyy in these merged word documents.

The date field is set as medium format in the database table and displays as dd-mmm-yyyy

How do I get the query used in the mail merge to force the date to be displayed as mmm-yyyy in my merged documents?
 
try this:

In the word doco select the mailmerge field. Right click Select Edit field
Select Field codes (bottom left corner)
at the end of the field codes insert: @\"mmm-yyyy"
You may need to set the field in your table to be a text field for this to work 100%
 
Force mail merged dates to display as mmm-yyyy

In the mailmerge document when I right click on the date field there are only the options toggle field/update field code.

When I insert @\"mmm-yyyy" at end of the field code it prints this out on the merged documents.

I thought I would have to keep the date fields in my access db set as dates in order to be able to do various date calculations, otherwise the date is displayed as a long number eg. 31102004

Any ideas what I'm doing wrong, or any other ways to force my mail merged dates to dsiplay as mmm-yyyy ie Oct-2004
 
chazer1 said:
The date field is set as medium format in the database table and displays as dd-mmm-yyyy

If you set the format in the table then it only acts as the display when viewing that table. It will not affect how it is formatted elsewhere such as in forms, queries, and reports.

Set the Format property of the field in your query to the desired format.
 

Users who are viewing this thread

Back
Top Bottom