Age old issue maximizing

[woodhouse]

Hi

I'm an old hand trying something new, many years ago I had a few databases where I would have the form miximze on open. The command DoCmd.Maximize doesn't fully work for me right now (it did some time ago so clearly something has changed). I've build a new DB, I have the form as I want it but it just won't maximize. On opening the form does try and miximize but then there is still a toolbar at the top, the toolbar says "home" and "Add-Ins". Most fucntions within home and add-in are disabled.

Any ideas where I'm going wrong?

Thanks for any help!!

Cheers

 

[NickHa]

Which version of Access are you using? If 2007 or 2010, the default mode is tabbed windows, where the DoCmd.Maximise doesn't work as you expect. Turn off tabbed browsing in the 'this database' options as a first suggestion.

 

[woodhouse]

Thanks Nick but no joy with that. I'm on 2007. I might try building in 2003 to see if that fixes it

 

[John Big Booty]

The Maximise command will not expand the Form to cover the tool bars, if that is what you are after have a look at this thread.

 

[woodhouse]

Thanks John. I did already try that, well somthing similar anyway. I used the following code which previously worked in 2003

Dim z As Integer
For z = 1 To CommandBars.Count
CommandBars(z).Enabled = False
Next z
Me.Caption = "my stuff"
DoCmd.Maximize

Still not joy though. the toolbar with home tab and add-in tab is still visible. anything ridiculously obvious i'm missing?

 

[John Big Booty]

Perhaps this thread has some info that will help

 

[woodhouse]

also I should point out I think the toolbar with home and add-ins on it is actually classed as the ribbon

 

[woodhouse]

you beauty! Thanks so much!! Cheers John