medium date format...

Yes, dates again..

ive been reading a lot, and got a few answers to my questions. anyway, i have an access project that uses dates stored in tables...

as usual, the date problem attacked me, making 05-06-2001 06-05-2001.

apparently this happens when the regional settings has a date format format different than the US one.

i solved my problem using "medium date format", had a few problems with abreviations, but my project works if you have the regional setting set to spanish only :(

now, i have 2 questions:

1. ive read that medium date format is not very good, and should not be used... is that true??? (an access MVP guy wrote that)

2. why when i create a form in access, and attach a textbox to a date field, access changes what the user type (05-06-2001) to (06-05-2001). this change is made automatically.