date changes from UK to USA format between Access and Word

[Dorrian]

In the Access data base it is in UK format, the letter is done in word under
UK format but when I migrate the date across it changes to USA format ie
month first. Can anyone tell me how to correct it. Short of redoing the
data base.

 

[Jerry Whittle]

Instead of using the data directly from the table, create a query and use the
Format function to force the date to look like what you want. Something like:

Format([YourDateField],"dd/mm/yyyy")

Then use the query in the merge.

Cheers!

 

[Dorrian]

Thank you for the suggestion. I tried what you suggested and it did not
work. It appears to be when the word programme takes it from the access. In
access it is ok in the form and query. Thank you anyway.

Instead of using the data directly from the table, create a query and use the
Format function to force the date to look like what you want. Something like:

Format([YourDateField],"dd/mm/yyyy")

Then use the query in the merge.

Cheers!
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

In the Access data base it is in UK format, the letter is done in word under
UK format but when I migrate the date across it changes to USA format ie
month first. Can anyone tell me how to correct it. Short of redoing the
data base.

 

[Allen Browne]

Jerry's suggestion will work.

Add an alias in front of the expression, e.g.:
NewName: Format([YourDateField],"dd/mm/yyyy")

Then merge the NewName field in Word.

The alternative is to add a formatting string as part of the field in Word
if you prefer to do it that way.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Thank you for the suggestion. I tried what you suggested and it did not
work. It appears to be when the word programme takes it from the access.
In
access it is ok in the form and query. Thank you anyway.

Instead of using the data directly from the table, create a query and use
the
Format function to force the date to look like what you want. Something
like:

Format([YourDateField],"dd/mm/yyyy")

Then use the query in the merge.

Cheers!
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

In the Access data base it is in UK format, the letter is done in word
under
UK format but when I migrate the date across it changes to USA format
ie
month first. Can anyone tell me how to correct it. Short of redoing
the
data base.