Disabling menu bar won't work

[andrewf10]

Here's a contender for the most ridiculous question ever posted on this brilliant site.

I'm attempting to disable the Menu Bar when my main form loads up. The code is standard stuff:

Private Sub Form_Open(Cancel As Integer)
DoCmd.ShowToolbar "Menu Bar", acToolbarNo
End Sub


But it only seems to work when I open the form in design mode and then go back to form view. It will not work unless I do this! Has anyone else ever seen this happen in Access 2000?

 

[jfgambit]

Under Tools>Start-Up disable the built-in toolbar option.

 

[andrewf10]

Thanks for pointing me in the right direction jfgambit.

After a fair bit of trial and error, I found the fix to be to set the "Allow built-in tollbars" flag to ON and then found this sentance on Access Help to back this idea up:

"If the AllowBuiltInToolbars property is set to False, you can't use the ShowToolbar action to display a built-in toolbar."