Disable copy, cut, and paste

Hi

We want to disable copy/cut on certain datasheets (sensitive data). Is
there a way to do this in Access?

I have a link to a way to do it in Excel:
http://www.xcelfiles.com/VBA_Quick13.html

Is there an equiv in Access, or a way to get the above to apply to Access?
FWIW, the MS Access app is going to be totally "baren", so all file menus
and buttons etc will be hidden as well.

Thanks
A

On Wed, 9 Nov 2005 11:16:30 +1300, "A C" wrote:

We want to disable copy/cut on certain datasheets (sensitive data).

Even if there is, there's NO way to prevent the user from capturing a
screenshot - with a hand-held digital camera, if nothing else.

John W. Vinson[MVP]

"John Vinson" wrote in message
...
On Wed, 9 Nov 2005 11:16:30 +1300, "A C" wrote:

We want to disable copy/cut on certain datasheets (sensitive data).

Even if there is, there's NO way to prevent the user from capturing a
screenshot - with a hand-held digital camera, if nothing else.

John W. Vinson[MVP]

Yes that is true, but as you say it is unavoidable so we are just trying to
do the best we can to make it harder...

Regards
A

On Wed, 9 Nov 2005 14:17:17 +1300, "A C" wrote:

Yes that is true, but as you say it is unavoidable so we are just trying to
do the best we can to make it harder...

You could set the Form's KeyPreview property to true, and trap the
Ctrl-C and Ctrl-X characters; and of course remove the Cut and Copy
options from the menu by using your own custom menu rather than the
default.

John W. Vinson[MVP]

"John Vinson" wrote in message
...
On Wed, 9 Nov 2005 14:17:17 +1300, "A C" wrote:

Yes that is true, but as you say it is unavoidable so we are just trying
to
do the best we can to make it harder...

You could set the Form's KeyPreview property to true, and trap the
Ctrl-C and Ctrl-X characters; and of course remove the Cut and Copy
options from the menu by using your own custom menu rather than the
default.

John W. Vinson[MVP]

Thanks John, those are good suggestions. Anyone else have any more ideas?

Its a shame Access does not have similar functionality to Excel as shown in
http://www.xcelfiles.com/VBA_Quick13.html. If anyone knows of how to do
similar to this link then please post.

Regards
Andrew

Do not forget about Ctrl+Ins and Shift+Del also

--
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com



"John Vinson" wrote in message
...
On Wed, 9 Nov 2005 14:17:17 +1300, "A C" wrote:

Yes that is true, but as you say it is unavoidable so we are just trying
to
do the best we can to make it harder...

You could set the Form's KeyPreview property to true, and trap the
Ctrl-C and Ctrl-X characters; and of course remove the Cut and Copy
options from the menu by using your own custom menu rather than the
default.

John W. Vinson[MVP]