Date format changes when merging to word

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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


Allen Browne said:
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.

rad said:
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
Click to expand...
Click to expand...
 
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.

rad said:
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


Allen Browne said:
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.

rad said:
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
Click to expand...
Click to expand...
Click to expand...
 
Got it! thanks for your help.
--
rad


Allen Browne said:
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.

rad said:
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


Allen Browne said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top