Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Gadget Gadget is offline
external usenet poster
 
Posts: 1
Default wrong date display in mail merge

Hello all,
I'm using XP, Access 2000 and word 2000. I have set up a simple databse and
mail merge letter. All the merge fields work fine except InsolvencyDate.
It is required that the date display in the mail merge letter as dd/mmm/yy,
but it displays as the american version, mm/dd/yyyy. I have checked regional
settings and have also set the format and input mask, both in the databsae
table and data entry form, but no change in the letter display.
Any ideas anyone? The letter is useless to my job the way it is.
Thanks in advance



  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default wrong date display in mail merge

Use Alt-F9 to display the "underlying field code" of your field, which
should look something like

{ MERGEFIELD "InsolvencyDate" }

or

{ MERGEFIELD "InsolvencyDate" \*Mergeformat }

then type a "date format switch" into the field so that it looks like

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

or

{ MERGEFIELD "InsolvencyDate" \@"DD/MM/YYYY" \*Mergeformat }

Make sure you use upper case MM and not lower case mm (which means
"minutes")
Click Alt-F9 again

Select the MERGEFIELD field and press F9

Try the merge again.

If that doesn't fix the problem, you'll need to create a new query in Access
to return the right result. But let's see if that is necessary first.

Peter Jamieson

"Gadget" wrote in message
...
Hello all,
I'm using XP, Access 2000 and word 2000. I have set up a simple databse
and
mail merge letter. All the merge fields work fine except InsolvencyDate.
It is required that the date display in the mail merge letter as
dd/mmm/yy,
but it displays as the american version, mm/dd/yyyy. I have checked
regional
settings and have also set the format and input mask, both in the databsae
table and data entry form, but no change in the letter display.
Any ideas anyone? The letter is useless to my job the way it is.
Thanks in advance





Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Previews Wrong Marge Mailmerge 6 January 6th 07 07:49 AM
mail merge putting fields in the wrong place! Disa Mailmerge 1 September 18th 06 09:24 AM
Mail merge data comes in wrong size font Why? Clarissa0046 Mailmerge 2 September 16th 05 06:06 AM
Wrong mail merge date format sam Mailmerge 1 June 8th 05 01:23 PM
Mail merge is using the wrong data base. Help. diamond4law Mailmerge 1 February 16th 05 12:21 AM


All times are GMT +1. The time now is 06:22 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"