Dear friends,
In my database i want to have 2 command buttons in order to enabled and disable the Shift control. Does anyone know the vba code which i must use for each case?
Regards
Dear friends,
In my database i want to have 2 command buttons in order to enabled and disable the Shift control. Does anyone know the vba code which i must use for each case?
Regards
As far as I know, you can't disable the keys directly. What you have to do is use the Key Preview event to check every keystroke to see if the shift/control key was pressed, and then cancel the event if it was.
If you are working with data entered through a form control, you can use an input mask to allow only lower case, or change the data to lower case in the After Update event.