Remove menubar/toolbar from Access Database 2

[postlethwaited]

Hi all, is there any way to remove all menubars from the top of an access database - i want to get rid of the bar that starts FILE EDIT etc etc. but don't seem to be able to - thanks in advance

 

[barrysprout]

Yes. You can create a blank menu and assign this as the default in your startup options. All forms and reports that don't have a custom menu will then use this one. Maybe there's another way but this works fine for me

 

[ssatech]

(2) Options:

1) You can either remove it using the On Open Event of your form.

Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = False
Next i

**Be careful because once you remove it - its gone. To get it back. Put a command button on your form to bring it back:

Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = True
Next i

2) Other way is just to remove the File, Edit, View etc so you just have the grey bar.

On the forms property, Go to Other, and on Menu Bar..... put the following like so: Menu Bar........ = -1

Try it