Deactivate DELETE button on the keyboard

[cenderawasih]

Hi....

Anybody knows how to lock the DELETE button function and the BACKSPACE button function on the keyboard? I need to disable these two key stroke so that the user can only do the deletion by clicking the Delete button on the form.....I have to force the user to use the delete button on the form because there are some coding that need to take place under the DELETE button.

Please help....

 

[danvlas]

AutoKeys macro (probably the ONLY macro worth keeping)...

Macro Name: {DEL}
Action: MsgBox
Message: "He he can't you just use the button?"

This will disable the Del key throughout the application.

For a specific form or control, you have to trap the key in the KeyDown event.

Good luck


Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[cenderawasih]

this codes works...i got it from another forum:

Private Sub txtDesc_KeyDown(KeyCode As Integer, Shift As Integer)
If ((KeyCode = vbKeyDelete) Or (KeyCode = vbKeyBack)) Then

KeyCode = 0

End If
End Sub