I use Access to merge with Word and when I merge to word the date comes out
in short format and I want long format. The date is from the table not a
query. The date format in Access is in long format.

Use a date switch on the merge field -
http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




PatAce wrote:
I use Access to merge with Word and when I merge to word the date
comes out in short format and I want long format. The date is from
the table not a query. The date format in Access is in long format.

Use a date format switch, e.g. press Alt-F9 in your Word mail merge min
document and modify e.g.

{ MERGEFIELD mydate }

to

{ MERGEFIELD mydate \@"DD/MM/YYYY" }

There's a list of the formatting options in Word Help.

Peter Jamieson

"PatAce" wrote in message
...
I use Access to merge with Word and when I merge to word the date comes out
in short format and I want long format. The date is from the table not a
query. The date format in Access is in long format.

Wouldn't that still be a short format ?

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Peter Jamieson wrote:
Use a date format switch, e.g. press Alt-F9 in your Word mail merge
min document and modify e.g.

{ MERGEFIELD mydate }

to

{ MERGEFIELD mydate \@"DD/MM/YYYY" }

There's a list of the formatting options in Word Help.

Peter Jamieson

"PatAce" wrote in message
...
I use Access to merge with Word and when I merge to word the date
comes out in short format and I want long format. The date is from
the table not a query. The date format in Access is in long format.

Yeah :-}

{ MERGEFIELD mydate \@"MMMM DD, YYYY" }

would be a better example.

Peter Jamieson

"Graham Mayor" wrote in message
...
Wouldn't that still be a short format ?

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Peter Jamieson wrote:
Use a date format switch, e.g. press Alt-F9 in your Word mail merge
min document and modify e.g.

{ MERGEFIELD mydate }

to

{ MERGEFIELD mydate \@"DD/MM/YYYY" }

There's a list of the formatting options in Word Help.

Peter Jamieson

"PatAce" wrote in message
...
I use Access to merge with Word and when I merge to word the date
comes out in short format and I want long format. The date is from
the table not a query. The date format in Access is in long format.

Thanks Peter and Graham. I used the word help but couldn't work out the
correct way to add the date. All makes sense now.

"Peter Jamieson" wrote:

Yeah :-}

{ MERGEFIELD mydate \@"MMMM DD, YYYY" }

would be a better example.

Peter Jamieson

"Graham Mayor" wrote in message
...
Wouldn't that still be a short format ?

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Peter Jamieson wrote:
Use a date format switch, e.g. press Alt-F9 in your Word mail merge
min document and modify e.g.

{ MERGEFIELD mydate }

to

{ MERGEFIELD mydate \@"DD/MM/YYYY" }

There's a list of the formatting options in Word Help.

Peter Jamieson

"PatAce" wrote in message
...
I use Access to merge with Word and when I merge to word the date
comes out in short format and I want long format. The date is from
the table not a query. The date format in Access is in long format.