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

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ncsthbell
    New Member
    • May 2007
    • 167

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

    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>Propertie s, 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?
    Thanks
  • Megalog
    Recognized Expert Contributor
    • Sep 2007
    • 378

    #2
    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

    Comment

    • ncsthbell
      New Member
      • May 2007
      • 167

      #3
      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.
      Thanks

      Comment

      • missinglinq
        Recognized Expert Specialist
        • Nov 2006
        • 3533

        #4
        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)>

        Comment

        Working...