default menu bar

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Does anyone know how to take out default menu bar? I have tried to delete the (default) option undermenu bar in startup, but that does not work.

Any suggestions or tips or much appreciated.

Christi
 
Chris;

Found this answer in Access help:

Setting

Enter the name of the menu bar you want to display. If you leave the MenuBar
property setting blank, Microsoft Access displays the built-in (default)
menu bar or the application's global menu bar. If you set the MenuBar
property to a value that is not the name of an existing menu bar or menu bar
macro, the form or report will not have a menu bar (the default menu bar
will not be shown).

HERE IS THE PROCEDURE I USE:

In the "Event" tab of the form or report: properties
Select "On "Open"
Click on the "..." Icon, click on Code.

Private Sub Report_Open(Cancel As Integer)
Reports.Application.MenuBar = "MyMenu" ' (I created a customized menu).
End Sub

Save it. Then when the form or report opens the customized menu is
displayed.

Ray; tried:
Private Sub Report_Open(Cancel As Integer)
Reports.Application.MenuBar = "george"
End Sub

George being the name of a menu that doesn't exist, as suggested in the
Access Help. Got an error message, but it may work in your version of
Access.

To re-display your standard menu:
In the "On Close" event code:

Private Sub Report_Close(Cancel As Integer)
Reports.Application.MenuBar = ""
End Sub

Hope this helps.

Andy
Chris said:
Hi,

Does anyone know how to take out default menu bar? I have tried to delete
Click to expand...
the (default) option undermenu bar in startup, but that does not work.
 
Back
Top