Date formate prob

[winterh]

One of my tables are link to a form which the user is allowed to input a date by hand or using the calendar function, the formate seems fine at this point.

The data then is used to merg into a word doc after a query has got all the information needed, but when it goes into the doc the formatting changes to USA, as you will understand you can not change the formate within word as it kills the merg field.

I am sure it is a simply fix but any help would be great.

[June7]

Could try using Format function on the date in a query. Format function results in a string value. Then reference this constructed field for the merge.