G
Guest
How can i stop /prevent/disable 'Ctrl C' ant 'Ctrl V' in a datasheet form
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
W
Wayne Morgan
In the form's Properties, set KeyPreview to Yes. Then in the KeyDown event,
try the following code:
Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
If (Shift And acCtrlMask) > 0 Then
If KeyCode = Asc("C") Or KeyCode = Asc("V") Then
KeyCode = 0
End If
End If
End Sub
This cancels the keyed entry. It won't prevent the user from using Copy and
Paste from the Edit menu.
try the following code:
Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
If (Shift And acCtrlMask) > 0 Then
If KeyCode = Asc("C") Or KeyCode = Asc("V") Then
KeyCode = 0
End If
End If
End Sub
This cancels the keyed entry. It won't prevent the user from using Copy and
Paste from the Edit menu.
G
Guest
thanks much appreciated