Lock Form Design

[brsawvel]

Hello World,

I am attempting to create a db that shows little to no relationship to Microsoft Access to the user as possible.
When I have my form open in "Form View", I am able to change the view to "Design View" by right clicking the control bar on the form.
Is there a way that I can remove that right-click option? Or at least, if that isn't possible, is there a way to remove the option to change the form to "Design View"?
I tried changing the control box option to "No", but it removes the icon (which I have a custom icon) and the "close" button, which I don't want to do.

Thanks,

brsawvel

 

[Guus2005]

I couldn't suppress the rightclick menu alltogether but was able to disable all options in the rightclick menu:

Select form in design mode and set properties:
Allow DataSheet View: No
Allow PivotTable View: No
Allow PivotChart View: No
Allow Design Changes: Design View Only

and create an MDE file of your app.

enjoy!

 

[boblarson]

You can get rid of the right click option by creating your own Context Menu and then assigning the menu to the form. To do so, check these instructions out:

http://articles.techrepublic.com.com/5100-10877_11-5772410.html

 

[jai kushwaha]

I want to lock ms access design view/ option by password. is there any way to do this plz help...

 

[Guus2005]

You can do this by using UAC. But if you start a new question instead of piggy bagging an eight year old answer you'll get a better answer.
Please do try!

HTH

 

[jai kushwaha]

You can do this by using UAC. But if you start a new question instead of piggy bagging an eight year old answer you'll get a better answer.
Please do try!

HTH

what is UAC

 

[CJ_London]

User Access Control - a wide subject so google to find out more