Weird Problem with DoCmd.Maximize

[Mark Andrews]

I have an Access2007 database that I would like to have a number of forms
maximized when they are opened and stay that way.

I put
DoCmd.Maximize in both the Form_Open and Form_Activate events

and sometimes it works fine and sometimes the form doesn't show up
maximized.

I test by opening the database and clicking on a custom ribbon button which
is set to open the form.

Anyone have any ideas? Do I have to put a loop around DoCmd.Maximize or
something?
Or do I have to goto some hack method just to get forms to maximize
consistantly in Access2007?

I have the database options set to overlapping windows.

Thanks in advance,
Mark

 

[Larry Daugherty]

Access has some dysfunctional behaviors. You're being plagued by one
of them. I don't know if they've fixed it in the latest iteration ...

If you absolutely, positively want a given Form always Maximized then
put your code in the OnCurrent event.

HTH

 

[Mark Andrews]

Thanks I'll give OnCurrent a try.

Access has some dysfunctional behaviors. You're being plagued by one
of them. I don't know if they've fixed it in the latest iteration ...

If you absolutely, positively want a given Form always Maximized then
put your code in the OnCurrent event.

HTH