Custom Menu bar

[Jollywg]

I'm working with Access 2007, and i was wondering how to put a custom menu bar in my form.

[patjones]

I'm working with Access 2007, and i was wondering how to put a custom menu bar in my form.

I looked into this a while ago. The answer is "sort of". You can create custom toolbar and/or ribbon items, but not traditional drop-down menus that will appear in the actual forms themselves.

In other words, if you create a set of toolbar items for a specific form, then, when you open that form, those items will appear in the toolbar along the top of the main Access window. And they will appear alongside the items that Access has already placed there by default, unless you turn those off.

I know exactly what you are looking for; I have had uses, at various points, for drop down menus embedded right in the forms. But unless there is some Visual Basic or XML code that I'm not aware of, it isn't possible to do it. If you have access to Visual Studio, and know a little about programming in VB .NET - it's possible to do anything you want. Unfortunately, there are limits to what Access allows in terms of front end development...

Also, see this thread: http://bytes.com/forum/thread496898.html.

Pat