Maximize opening screen

[Chum]

When I open an Access file, the box that appears first is not maximized. I have to click the maximize button on the top right of the screen. Is there any option available that will maximize this screen always when opening a file?

 

[boblarson]

Do you mean the whole Access window? If so, create a macro and name it AutoExec and use this action:

RunCommand

and the command to choose is: AppMaximize

and that should do it.

 

[John Big Booty]

You can also put the following code in the On Load Event of your Welcome Form (that the form that you select in the Tools, StatUp menu Display Form/Page:;

DoCmd.RunCommand acCmdAppMaximize

This will maximise the application window if however you want the form maximised use;

DoCmd.Maximize

In the forms On Load event

 

[Chum]

Do you mean the whole Access window? If so, create a macro and name it AutoExec and use this action:

RunCommand

and the command to choose is: AppMaximize

and that should do it.

The window I'm referring to is the window after opening, the window that gives you the choices: Table, Queries, Forms, etc.

 

[boblarson]

The window I'm referring to is the window after opening, the window that gives you the choices: Table, Queries, Forms, etc.

That is called

in 2003 and earlier - the database window

in 2007 and above - the Navigation Pane

Which one are you dealing with? If 2003 or below, if you used the AutoExec Macro you can add an Action of RunCommand and the Command is DocMaximize. If you used the other through code you can use

DoCmd.RunCommand acCmdDocMaximize

In 2007 or 2010, while you have the database open you can drag the Nav Pane over as far as you want to and then it will be that way every time you use it until you change it back. However, in that instance it makes no sense to do so since it doesn't display the objects in more than one column down the page.