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?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor 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
 
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
All Courses

From novice to tech pro — start learning today.