Disable delete key? (Access 2002)

Topic

New Reply

Is there a way to disable the delete key?

Reply | Quote

Replies

Where do you want to disable the Delete key?

Throughout the database?

Create a new macro.
Display the Macro Name column.
Enter {DELETE} in the Macro Name column.
Save the macro as AutoKeys (this name is mandatory).

AutoKeys will be run automatically.

In a specific form?

Open the form in design view.
Activate the Event tab of the Properties window.
Set the Key Preview property to Yes.
Create an On Key Down event procedure for the form:

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = vbKeyDelete Then
KeyCode = 0
End If
End Sub

In a specific control?

Open the form in design view.
Select the control.
Activate the Event tab of the Properties window.
Create an On Key Down event procedure for the control:

Private Sub ControlName_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = vbKeyDelete Then
KeyCode = 0
End If
End Sub

Replace ControlName with the name of the control.

Reply | Quote

Nice summary!

Reply | Quote

Thanks Hans!

Reply | Quote