(Sorry for posting this to both Forms and VBA. It's my first time using this website and I missed VBA.)
Hello everyone,
I am trying to figure out a way to PREVENT users from pasting information from the windows clipboard into a field, or into the form altogether--whichever is easier.
I need both the Menu>Edit>Paste and Ctrl+V functions to be disabled.
I have thought about comparing the field's data to the data on the clipboard anytime a field was changed to see if they match; however, I do not know how to reference the clipboard other than actually pasting it (DoCmd.RunCommand acCmdPaste). I suppose that I could create a blank field, use the command to paste to the blank field, and then compare; however, this would only catch times when an entire field was pasted (not just a portion of the field).
I am unsure how to go about this and would appreciate any tips anyone has.
Thanks for any help in advance!
John
Hello everyone,
I am trying to figure out a way to PREVENT users from pasting information from the windows clipboard into a field, or into the form altogether--whichever is easier.
I need both the Menu>Edit>Paste and Ctrl+V functions to be disabled.
I have thought about comparing the field's data to the data on the clipboard anytime a field was changed to see if they match; however, I do not know how to reference the clipboard other than actually pasting it (DoCmd.RunCommand acCmdPaste). I suppose that I could create a blank field, use the command to paste to the blank field, and then compare; however, this would only catch times when an entire field was pasted (not just a portion of the field).
I am unsure how to go about this and would appreciate any tips anyone has.
Thanks for any help in advance!
John
