By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,510 Members | 1,451 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,510 IT Pros & Developers. It's quick & easy.

Access: How to disable data copying from datasheet form

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.