Show UK dates on Recipient List in Mail Merge Wizard

[Guest]

My list shows the dates in US format, month day then year, although it was
produced in access in UK format. I have entered field switches which work
on 23/4/04 but not when field show 3/1/04 meaning 1st March 2004 as in the
merge document it shows 3rd January 2004. All other controls are shown in UK
format.

I use Office 2002

 

[Arvin Meyer]

All SQL dates must be formatted in US format, but you can format the report
dates any way you want. In the format property on the text box's property
sheet, enter the following:

d/m/yy
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Access will pick up the regional settings on your PC and use that format to
display dates, etc. unless you specify otherwise. To force it display
dd/mm/yyyy use:

Format([MyDateField],"dd/mm/yyyy")