I have an Access table with a date field. The format is set to long date. The data in the field appears as: Wednesday, November 5, 2001 in the table but when I merge the table into a Word document it appears as 11/05/01. Is there any way I could spell it out in the merged document?
Merge document field format (1 Viewer)
- Thread starter robert693
- Start date
- Local time
- Yesterday, 19:45
- Joined
- Feb 28, 2001
- Messages
- 27,193
Don't do the MailMerge directly from the table.
Build a query that contains every field you need. But for the date field, don't include [DateField] in the query grid. Instead, include Format([DateField],"longdate") (or whatever the correct name is.)
If you import through the query, Word is too dumb to care about the difference. To Word, a data source is a data source. If you get Access to do some of the formatting in the query, you'll have that much less to do in Word. (Which is good because by the time it gets to Word, you can't do much else with it.)
Build a query that contains every field you need. But for the date field, don't include [DateField] in the query grid. Instead, include Format([DateField],"longdate") (or whatever the correct name is.)
If you import through the query, Word is too dumb to care about the difference. To Word, a data source is a data source. If you get Access to do some of the formatting in the query, you'll have that much less to do in Word. (Which is good because by the time it gets to Word, you can't do much else with it.)
Similar threads
