Disable default Menu Bar

[Guest]

Hello!
This is a simple question, unfortunately not for me (
I've got a database in which there are almost all toolbars are hidden except of 'Menu Bar" while it opens. This database has few forms, and one of them - which is not loaded first (Form14) has a textbox called Text52. What I want to acheive is to disable even "menu Bar" depending on value from Text52. e.g.:
This is the code which runs on onOpen form's event:

If Forms!Form14!Text52 = "1" Then
DoCmd.ShowToolbar "Menu Bar", acToolbarNo
End If

But nothing really happens, the "Menu bar" is still displayed

Can anybody help me?
Thanx in advance

 

[Marshall Barton]

Hello!
This is a simple question, unfortunately not for me (
I've got a database in which there are almost all toolbars are hidden except of 'Menu Bar" while it opens. This database has few forms, and one of them - which is not loaded first (Form14) has a textbox called Text52. What I want to acheive is to disable even "menu Bar" depending on value from Text52. e.g.:
This is the code which runs on onOpen form's event:

If Forms!Form14!Text52 = "1" Then
DoCmd.ShowToolbar "Menu Bar", acToolbarNo
End If

But nothing really happens, the "Menu bar" is still displayed

Try moving the code to the form;s Load event or where ever
the value of Text52 is set.