merging data into Word and getting rid of time stamps

  • Thread starter Thread starter King Kaos
  • Start date Start date
K

King Kaos

I have a query/table that merges several dates into a Word Doc. I've set
the table, query, and the form I use to the Short Date - however, it
contniually merges into Word with the Date and Time stamp - is there any way
to fix this

Thanks

keith
 
I would think you would change the properties of the merge field in WORD.
Post your question in a WORD newsgroup.


Rick B
 
I have a query/table that merges several dates into a Word Doc. I've set
the table, query, and the form I use to the Short Date - however, it
contniually merges into Word with the Date and Time stamp - is there any way
to fix this
Click to expand...

Use a Query with a calculated field:

ExpDate: Format([datefield], "mm/dd/yyyy")

This will convert the Date/Time field to a text string. Mail merge
ignores the format properties of fields and form controls so you need
to actually recast the value into a Text using the Format function.

John W. Vinson[MVP]
 
Back
Top