Date format changes when merging to word

[Guest]

I am trying to merge a tennis club data base to word based membership renewal
forms but the date of birth reformats from dd/mm/yyyy to m/d/yyyy

 

[Allen Browne]

In Word, you can right-click the field and set the format you want to see,
as a switch in the field.

Alternatively, you can create a query and type an expression like this into
the Field row:
DOB: Format([date of birth], "dd\/mm\/yyyy")
Access treats this as being text, so when you merge this text into Word it
doesn't get reformatted.

 

[Guest]

Thanks Allan, what value would I enter as a switch in the merge field in Word
to reformat the date to 'dd/mm/yyyy'
--
rad

In Word, you can right-click the field and set the format you want to see,
as a switch in the field.

Alternatively, you can create a query and type an expression like this into
the Field row:
DOB: Format([date of birth], "dd\/mm\/yyyy")
Access treats this as being text, so when you merge this text into Word it
doesn't get reformatted.

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

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

I am trying to merge a tennis club data base to word based membership
renewal
forms but the date of birth reformats from dd/mm/yyyy to m/d/yyyy

 

[Allen Browne]

Right-click the field in your Word document.
Show the field rather than the value.
Word will show you the switch to add to the field.

(I don't recall if from memory; you can find it in Word's help.)

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

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

Thanks Allan, what value would I enter as a switch in the merge field in
Word
to reformat the date to 'dd/mm/yyyy'
--
rad

In Word, you can right-click the field and set the format you want to
see,
as a switch in the field.

Alternatively, you can create a query and type an expression like this
into
the Field row:
DOB: Format([date of birth], "dd\/mm\/yyyy")
Access treats this as being text, so when you merge this text into Word
it
doesn't get reformatted.

I am trying to merge a tennis club data base to word based membership
renewal
forms but the date of birth reformats from dd/mm/yyyy to m/d/yyyy

 

[Guest]

Got it! thanks for your help.
--
rad

Right-click the field in your Word document.
Show the field rather than the value.
Word will show you the switch to add to the field.

(I don't recall if from memory; you can find it in Word's help.)

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

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

Thanks Allan, what value would I enter as a switch in the merge field in
Word
to reformat the date to 'dd/mm/yyyy'
--
rad

In Word, you can right-click the field and set the format you want to
see,
as a switch in the field.

Alternatively, you can create a query and type an expression like this
into
the Field row:
DOB: Format([date of birth], "dd\/mm\/yyyy")
Access treats this as being text, so when you merge this text into Word
it
doesn't get reformatted.

I am trying to merge a tennis club data base to word based membership
renewal
forms but the date of birth reformats from dd/mm/yyyy to m/d/yyyy