Ms Access Date input field behaving strangely. (1 Viewer)

lovBah

New member
Local time
Today, 07:26
Joined
Oct 13, 2021
Messages
11
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.
 

gemma-the-husky

Super Moderator
Staff member
Local time
Today, 05:26
Joined
Sep 12, 2006
Messages
15,614
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.
 

lovBah

New member
Local time
Today, 07:26
Joined
Oct 13, 2021
Messages
11
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: 95

gemma-the-husky

Super Moderator
Staff member
Local time
Today, 05:26
Joined
Sep 12, 2006
Messages
15,614
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

Top Bottom