By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,790 Members | 1,398 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,790 IT Pros & Developers. It's quick & easy.

In form view, how do I disallow use of right click- properties of textbox on form

P: 167
When my form is in form view, I have users that have learned how to 'right click' on a text box and they are actually going into the properties and changing the control source.
Under Tools>Properties, Protection tab, I have set a password. Is there some way I can 'lock' the forms so the users can not use this method to change things?
Feb 5 '09 #1
Share this Question
Share on Google+
3 Replies

Expert 100+
P: 378
I usually just create an MDE/ACCDE file for the users. I'm pretty sure that even with a full Access installation, you cant change form properties in those formats.

In Access 2007, it's found at: Database Tools > Make ACCDE
Feb 5 '09 #2

P: 167
I am using MS Access 2000, this is what I see:
Tools>Database Utilities>Make MDE file

I will have to research more to learn about what an 'MDE' file is and how it affects the application.
Feb 5 '09 #3

Expert 2.5K+
P: 3,532
The obvious question, of course, is why in the world would they want to do this? The next point is that they need to be made aware that they are damaging company property. I know of a company that made this behavior cause for immediate discharge from employment and amazingly, the problem went away!

Having said that, in Design View you can goto Properties - Other and set the Allow Design Changes Property to Design View Only.
This will disable Properties when you right click on a control on the form. The problem is, they can still right-click on the title bar and use it to go into Design View.

Do they have any legitimate reason to use the shortcut menu? If not, you can goto Properties - Other and set the Shortcut Menu Property to No. This won't allow any right-click to work.

If neither of these suits you'll have to follow Megalog's suggestion. An MDE file locks down the app so that no design changes can be made to it. If you got the MDE route, remember to always keep a safe, backup of the MDB file! You'll need this file to make any modifications down the road.

Linq ;0)>
Feb 5 '09 #4

Post your reply

Sign in to post your reply or Sign up for a free account.