How to detect when a user tries to copy a row on a datasheet view

[EddieN1]

I am running Access 2007. I have a simple form in datasheet view. Sometimes the operators try to "copy & paste" an existing row onto a new row. How can I detect the "copy" part of the process and tell the operator he can't do that? Although they can copy & paste data from individual fields, I don't want them to be able to copy an entire row.



Thanks, Eddie

[John_G]

One thing you could do, if possible, is put a unique index on a field (or combination of fields) that the users see and try to copy; then if they do a copy - paste of an entire row, the paste will generate an error which you can trap, issue an error message, and undo the paste.

Beyond that, I don't know of a way to detect what data is selected when the "Copy" is done.

HTH

John