Hiding toolbar?

[BAX5127]

I was able to find some code to hide the toolbar but I am unclear as to where the code should go.

Here is some code I found:
Dim i As Integer


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

and

DoCmd.ShowToolbar "Menu Bar", acToolbarNo

I have tried putting in the second code but because it didn't work I am assuming that I didn't have it in the correct spot. Any help would be great thanks.

[timmy]

If by toolbar you mean the ribbons, put this behind the first form that is loaded:

 
Private Sub Form_Load()
DoCmd.ShowToolbar "Ribbon", acToolbarNo
End Sub

Edit: to show the ribbons again, hold shift when opening the DB.

[BAX5127]

Thanks timmy. It worked just like I needed it to.