Ms Access Date input field behaving strangely.

can you enter anything in the empname column?
can you change the value of an existng record?

wrong error message but just wondering if you have locked the table in some way or have the app in a read only folder
I just created that sample DB on my documents. the tables are not locked. in the main Db you can change any values in any fields. The problem is the date fields you can't enter any new value. the error will show up. so right now I cant tell what's going on. so i thought it might be access date setting or regional date setting etc.
 
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: 142
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