Access 2007 Use application.setoption to allow full menus

The edit form link on combo boxes disappears if you uncheck the allow full menu options in the access options/current database.

 I Looked at this:
Application.SetOption "Show Status Bar", True
As a way of temporarily allowing full menus so I could get the automatic link.

But I cannot find the correct text string for the allow full menus option (allow full menus and many guesses dont work). Is there one?

I need this because it looks like its extremely difficult to create pop up menus of your own  in Access 2007 . A simple button does what I want but  would get overlapped by  the combo box list. I need a floating pop up. Theres loads of help for earlier versions but not 2007. In fact there is nothing about how to create a pop up?  I  have a question open on how to do it : http://www.experts-exchange.com/Microsoft/Development/MS_Access/Access_Forms/Q_23138105.html

Thanks Lou
LouverrilAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
That should be AllowFullMenus:

Application.SetOption "AllowFullMenus", True

http://msdn2.microsoft.com/en-us/library/aa662934.aspx

However, many of these settings cannot be changed in the current session of Access. In other words, using SetOption would change the option for the next time you open your database. Generally you'd need to build your own menus for a deployed application and use those, however ...

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
LouverrilAuthor Commented:
Thanks LSM ,

When I use this I still get an error message
"2091 "AllowFullMenus" is an invalid name"

I am trying to use it in a button though - so it's either
- becuase its not valid due to a restart being needed (which it is if you select via the current database option from the office button)
OR
- because it's not valid in 2007 - the article you ref is 2003.

Either way I think a restart is needed therefore it's not going to do what i want anyway.

I'm giving up and creating a button using
 DoCmd.RunCommand acCmdEditListItems
and just trying to put a button where it wonnnnn't get hidden by the combo box.

Thanks for your help.  The suggestions will be useful in the future.

Lou
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.