Odd Behavior In Spanish vs. English

[Someone]

Hello,

Setup Info: Access97 database, date fields are in Short Date format

Scenario: Using English (US) regional settings, I can open a form
(displaying shipments on a particular date) from another form based on the
date entered into an unbound text field. When I change the regional setting
to Spanish (Mexico), the only way the same function works is if I use
format(txtShipDate,"Short Date"), even though the txtShipDate field is
formatted as short date. In the database, the field displays as 06/10/2004
in English and 10/06/2004 in Spanish, and the input field displays likewise
in both instances.

Any ideas why the need to format the field?

Thanks,
James

 

[Douglas J. Steele]

Because Access was developed in the US, many of the date-related features do
not respect the regional settings, but insist on mm/dd/yyyy format.

Take a look at Allen Browne's "International Dates in Access" at
http://members.iinet.net.au/~allenbrowne/ser-36.html or what I have at
http://members.rogers.com/douglas.j.steele/SmartAccess.html