Access: How to disable data copying from datasheet form

  • Thread starter Thread starter ANSWER
  • Start date Start date
A

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
 
I would use the api call EmptyClipboard at an appropraite
moment. I haven't had a chance to look at the events of a
datasheet view. It also depends which version of Access as
well.

Declare Function EmptyClipboard Lib "User32" () As Long

Alastair
 
I'm a newbe who's converted excel data to access. I had lots of problems
with others modifying the data that I maintain. Not wanting to fix their
error with a ruler across the knuckles, converting to access helped mess
them up and keep my data. This sounds like a further option for me to use
but I'm not familiar with the process of locking and disabling a column, how
would I do that, please?
 
In design view select the control, bring up the properties box & set the
properties
HTH
Pieter
 
Back
Top