By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,122 Members | 927 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,122 IT Pros & Developers. It's quick & easy.

Mail Merge with Access and Word

P: n/a
I am new here, so please bare with me.

I have merged an Access query into Word, and the date field and time
field display different input masks than how they are set up in
Access.

I have checked the forms and tables, and the properties on these
fields are all set with the proper input mask, but they display
differently once merged with Word.

Ex: In Access, the input mask for the date field is long date, but it
displays as a short date once merged into Word.

Any help is greatly appreciated.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

"Red&LimeStripes" <ks****@usm.maine.edu> wrote in message
news:bc*************************@posting.google.co m...
I am new here, so please bare with me.

I have merged an Access query into Word, and the date field and time
field display different input masks than how they are set up in
Access.

I have checked the forms and tables, and the properties on these
fields are all set with the proper input mask, but they display
differently once merged with Word.

Ex: In Access, the input mask for the date field is long date, but it
displays as a short date once merged into Word.

Any help is greatly appreciated.

You must force Word to use your preferred date format by using what Word
calls 'field switches' and are set up from the Word document or template.
You can get full details from the help file but in your case you simply need
to make sure your merge field says something like: { MERGEFIELD MyDate \@
"dd/MM/yyyy" }

Note you must use capital M for month - lower case m is for minute.

HTH

Fletcher
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.