Form Full Size on Start Up

[GregD]

This is very odd. We have a dozens of Access databases at work. Most use the same start-up form which is copied in to every database. It allows the user to select a SQL server and then tables are re-linked accordingly.

In one Access database the form opens full-screen and then all subsequent forms are full screen as well. It is very annoying. I have compared the properties of that form to the same form in other dbs and they are identical. I have compared the Start Up properties, Options, and Customize settings of that db to other dbs and they are identical.

Any ideas what would be causing this.

Greg

 

[boblarson]

What's causing this is a normal Access behavior that has been with it since I can remember.

If you maximize one object - everything is maximized. If you don't want the other things maximized, you have to either:

Open subsequent forms/reports as POPUPs or if you close the other form, in the close event you can put DoCmd.Restore which will set things back to a normal, non-maximized states.

 

[GregD]

You're right that it is normal behavior and it is not just Access. Any MDI (multiple document interface) application is like this. If one form or document is maximized they are all maximized. If one is normal they are all normal.

The odd thing here though, is that the first document should not be loaded maximized. In fact, it comes up normal and then a second later it maximizes. This same start up form in all other dbs comes up normal and stays normal. Even on other dbs that don't use this start up form the first form is not maximized so all subsequent forms are loaded not maximized. In this one db the first form loads maximized instead of normal.

Greg

 

[boblarson]

Check the On Open or On Load events to make sure it doesn't have any DoCmd.Maximze code anywhere. Also, how is the initial form opened? Is it set in the Startup options or opened using an AutoExec macro? If the macro is being used it could have it set to maximize when opened, so check that out.

 

[GregD]

AutoExec! That was it. This is one of the many reasons why I hate macros and never use them. IMO, their only use is for scheduling tasks with Access to run in the middle of the night.

It was also set as the Start up form, so that is what I was looking at. This has been bothering me for a few years, but it was not a big issue. Last month we upgraded our SQL Server and I had to change all of these start up forms in a few dozen databases. I did this programmaticaly by looping through a list of DBs and using Docmd.TransferDatabase, so I knew everything was identical now. Still, that form came up maximized.

Thanks!

Greg