date format frustration

[Guest]

Pleeeeezze help, I'm going nuts here!
I have created a mail merge letter using data from an Access.mdb table. The
date format in the table is dd/mmm/yy. When I merge the data into the mail
merge letter, the format appears as mm/dd/yyyy.
Why is this happening and how do I rectify the problem?
Any help on this would be gratefully appreciated. Thank you.

 

[Douglas J. Steele]

Create a query based on the table, and use the Format function (not the
field's Format property) to format the date as desired.

Merge using the query, rather than the table.

 

[Al Campagna]

Gadget,
That "may" be due to your Regional Setting in your system Control Panel...

Did you format the field in the report as mm/dd/yyyy?
"Your payment is due on " & Format([YourDateField],"mm/dd/yyyy") & "."

You should be able to format that field in the query field Properties also.

Or, or try a calculated field in the query.
Ex.
FmtDate : Format([YourDateField],"mm/dd/yyyy")
"Your payment is due on " & [FDate] & "."
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[Peter Hibbs]

Gadget

You might also want to have a look at
http://word.mvps.org/FAQs/MailMerge/index.htm
which shows how to format mail merge date type fields in Word.

HTH

Peter Hibbs.