Access: How to disable data copying from datasheet form

[ANSWER]

I have main form who contains subform in datasheet.
I want to disable (selecting one column and then Ctrl + C).
I just want them to see results in datasheet but not to copy data form
datasheet.

Thanks in advance

[Terry Kreft]

Set the KeyPreview property of the form (subform) to Yes.
In the code behind the form put

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
Select Case (Shift = acCtrlMask)
Case True
Select Case KeyCode
Case vbKeyC
KeyCode = 0
End Select
End Select
End Sub

This will prevent Ctrl + C from being processed.

--
Terry Kreft
MVP Microsoft Access
"ANSWER" <no****@nospam.com> wrote in message
news:c6**********@ariane.blic.net...

I have main form who contains subform in datasheet.
I want to disable (selecting one column and then Ctrl + C).
I just want them to see results in datasheet but not to copy data form
datasheet.

Thanks in advance