europe date format / input mask

[Guest]

Is there a way to display a date and it's input mask to work with dd/mm/yy.
I change the format property as dd/mm/yy and this let me see the date as
the requested format.
BUT when i try to key in the date ( i have select europe date as input mask
in access 2003, which 99/99/00;0 access try to read it as mm/dd/yy.

is it possible without changing the regional setting !!
thanks a lot

 

[Allen Browne]

See:
International Date Formats in Access
at:
http://allenbrowne.com/ser-36.html

IMHO, input masks on date fields are about as useful dinosaur repellent.
They do contribute nothing towards correct date formats, so serve only to
slow down good data entry operators.