How to Disbale Form Header Icon

[The Professor]

Hi,

I'm displaying my Forms in full screen mode, with a tab style header (as opposed to pop-up mode) which is fine, that's what I want.

However, next to the Form name on the tab, an Access icon appears (I don't know what it's called) but if you right-click it, a short drop-down menu appears - and this is what's causing me the problem, that menu allows access to Design View, among other things, and therefore I want to disable it. Can I do that? And if so, how?

I notice that if I change the Form mode to PopUp, that same right-click, drop-down menu has different options and Design View is not one of them.

Thanks
Prof.

[rpeare]

If you set your form to pop up the menu option for design view won't be available, and that's what you want. So what is the problem exactly?

[The Professor]

I did briefly try it as a pop-up when I first started building this database, but it just doesn't work with the look and feel of the database as I wanted it. It's not the only form by any means, and unlike the tabbed form interface, it becomes awkward when more than one Form is open, or when you're viewing reports or queries - you have to close one form pretty much every-time you open something else; in short the tabbed interface works far better. So now, how do I disable the icon (does anyone know what its called?) or at the very least remove 'design view' from the drop down menu?

Prof.

[rpeare]

Look at the SHORTCUT MENU option, set it to NO

[The Professor]

Hi rpeare, and thanks for your reply.

I had already tried that before starting this thread, but it doesn't work - meaning it doesn't stop the Access icon appearing. Whether the Shortcut Menu option is set to Yes or No, the Access icon still appears next to the Form name, and the right click dropdown menu is still available. I have to say this has me scratching my head.

[rpeare]

Are you talking about on the ribbon bar or on the form itself. I don't have access 2010 and I don't have an access icon on my form itself. There's a little form icon right next to the form name at the top of the form but right clicking on that does nothing in my version.

[The Professor]

Hi, and thanks again for your help.

No, not talking about the Ribbon, but the Form itself - yes the little Form Icon (or whatever it's called) next to the Form name. In my version of Access (2010) if you right-click on that, a drop-down menu appears - I want to disable that.

Anyone out there with Access 2010, knows how to do this?

Prof.

[rpeare]

have you tried changing the border style (thin gets rid of the icon/form name bar altogether). Another option is to create a custom menu and use that instead of the default. I don't have access to a 2010 version to mess around with it more than to check a few things, sorry.

[The Professor]

Hi rpeare, thanks for your help, and no need to be sorry - any time you can give is much appreciated. I'll have a go with the borders, as I have no idea how to create a custom menu to replace the default drop-down one - sounds like a task outside my skill level!

Prof.

[The Professor]

I've had a go at using the different border options, but it seems that when you use the default Form format in 2010 (the tabbed format) the border settings don't have any effect, as, I suppose, there are no borders as such, because the Form effect fills the available screen space. Prof.

[rkalapura]

If you want, you can Switch off the tabs permanantly. Or you can choose an overlaping tab arrangment. To choose any of these case, you need to start your database in 2010, Click on "File" then choose "Option" then "Current Database". Under "Application Option", you will find these options available. If you uncheck the checkbox of "Display Document Tabs", you wont get any tabs while opening forms/reports/tables and querries. If you choose option button clicked on "Overlapping Windows", you always have one tab even if you open more than one item in your database.

You can choose the best for your scenario by changing these settings.

I've had a go at using the different border options, but it seems that when you use the default Form format in 2010 (the tabbed format) the border settings don't have any effect, as, I suppose, there are no borders as such, because the Form effect fills the available screen space. Prof.

[The Professor]

Hi rkalapura,

Thank you for that. I had a look at the options you mention, and I did experiment with various of the settings, but found that none of them worked any where near as well as the default tabbed option.

I had hoped that there would be a simple way (either through VBA code, or an option setting) to disable the right-click menu in the Form's tabbed header icon - it seems there isn't. So I've decided that I shall just have to live with it and hope the user doesn't realise that they can access the design option via this right-click drop-down menu - that can't be disabled.

Prof.

[TG_W]

Why not make your database an ACCDE one when you are done? You can roll out changes in phases. Just keep a revision number going in the title.

[The Professor]

Hi TG_W,

Actually, that's a very good suggestion. I've looked-up ACCDE and it seems to be just what I'm looking for. Thank you.

Prof.