Disable Shift Control

[gstylianou]

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

[John_G]

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.