The command you're using is correct if what you're trying to do is maximise the amount of space you have on screen. If you just want to get rid of the stuff from the ribbon then you are going to have to look at creating an XML file as described in one of the other answers.
The code works for me so there must be something else going on in your Database that's switching the ribbon back on. Have you searched for other occurences of the ShowToolbar in code or macros? Or maybe a SendKeys?
--- In MS_Access_Professionals@yahoogroups.com, "Bradley" <bradgriffis@...> wrote:
>
> Hello, I want to hide the ribbon on my database. I put the following code in the "On Open" event of my startup form "FrmMaster," but the ribbon still appears. What am I doing wrong? My test database is "TimeTool_3" in the "PTS Time Tool" folder. I use Access 2007 and my experience level is beginner.
>
> Private Sub Form_Open(Cancel As Integer)
> DoCmd.ShowToolbar "Ribbon", acToolbarNo
> End Sub
>
>
> Thanks,
>
> Brad
>
Tidak ada komentar:
Posting Komentar