Disable right click and paste for form controls

[Robyn_P]

Hello,



I'm trying to ensure that people can't paste into a form on my database as it has stringent text validation rules that pasting circumvents. I have managed to disable ctrl V but people an still paste using right click and paste. How can I stop this? I found an article with instructions on creating a custom shortcut menu but it was for Access 2003 and I'm using 2010 so it doesn't work. Any help would be appreciated.

[Bob Fitz]

You could UNtick the "Allow Default Shortcut Menus"but this would also make make the right click menu unavailable for reports as well.

[davegri]

You can disable the right click menu individually for forms:

[Robyn_P]

You could UNtick the "Allow Default Shortcut Menus"but this would also make make the right click menu unavailable for reports as well.

That would probably work. They shouldn't need to right click at all (if I've done my job right). Where do I find this setting?

[Robyn_P]

Thanks davegri, that's perfect and very simple, didn't know you could do that

[Missinglinq]

Just out of curiosity...what kind of text validation would be circumvented by pasting?

Linq ;0)>

[Robyn_P]

When I said "extensive" I may have been exaggerating to make it sound more impressive as it is. It's simply code that prevents certain characters being entered /"\& etc. The form takes inputs and uses them to automatically create directories on the drive so the text can't contain special characters that would make the dir command fail, the most common being the \. If you copy paste, the on_keypress code isn't executed so you can enter anything you want

[Bob Fitz]

When I said "extensive" I may have been exaggerating to make it sound more impressive as it is. It's simply code that prevents certain characters being entered /"\& etc. The form takes inputs and uses them to automatically create directories on the drive so the text can't contain special characters that would make the dir command fail, the most common being the \. If you copy paste, the on_keypress code isn't executed so you can enter anything you want

You could put your validation code in the control's BeforeUpdate event or the Form's BeforeUpdate event, then you could allow use of the right click menu.