"colmkav" <co******@yahoo.co.ukwrote in message
news:11*********************@c35g2000hsg.googlegro ups.com...
Hi, can someone tell me how I change the settings in my Access 97 to
default to English dates rather than US dates?
I notice all my dates like 1/5/2007 is being treated as 5th Jan 2007
rather than 1 May 2007.
That is a Windows setting, not an Access setting. Further if you are talking
about how date literals are interpreted in code and queries, any time you use an
ambiguous format Access will *always* assume US format first unless that results
in an invalid date value. For those situations you are best served using a
non-ambiguous format like ISO yyyy-mm-dd.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com