Ms Access Date input field behaving strangely.

It's working for me

See what your regional settings is set to, out of interest, and see what the date display is set as.
I've seen problems with a system set to a caribbean setting.
 
It's working for me

See what your regional settings is set to, out of interest, and see what the date display is set as.
I've seen problems with a system set to a caribbean setting.
 

Attachments

  • 2021-10-26 (2).png
    2021-10-26 (2).png
    64.2 KB · Views: 159
So that's showing the date format as dd/mm/yyyy
Maybe that's why entering the date with dashes as dd-mm-yy fails. (although I just tried and either worked for me)

It looks odd though as I thought one of your screenshots showed dates entered in both formats.
(no that's not right. It rejected the entry with slashes as the separator - very strange)
 

Users who are viewing this thread

Back
Top Bottom