Access window small when opening

[Rick]

Silly question...
I have a database opened at all times while I am at work.
Sometimes I need to open one of three or four other
databases in a separate window. If I browse to the folder
and double-click on the icon to open one of these, the
MSAccess window that opens is only about 1/3 the width of
my desktop. After I enter my password and the switchboard
pops up, I maximize the window. My switchboard remains
squeezed to the left side of my window.
How can I tell it to open Access in a maximized window?
The first database I mentioned (the one I use all the
time) always seems to open properly.

Thanks!!

Rick

 

[Van T. Dinh]

In the Activate Event of the Switchboard Form, use the statement:

DoCmd.Maximize

 

[Jim/Chris]

Create a macro and name it "Autoexec"
macro command RunCmd
Action AppMaximinze

Jim

 

[Graham R Seach]

Rick,

Using DoCmd.Maximize will maximize the database window and all your forms.
If this is OK, then use that approach.

As I recall, Windows opens an application at a size that depends on the
currently available resources. So if your system is running low on memory,
it will open the window smaller.

If you are launching your application from a shortcut, select Maximized from
the shortcut's Run drop-down. You can get at this by right-clicking the
shortcut, and selecting Properties from the context menu.

Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[Rick]

This works, but only after the database has loaded and the switchboard is
displayed. It forces the form to the left of the screen. If I have no
other MSAccess windows open, then my application opens fine. It is only
when I am opening a second instance of MSAccess that the window is smaller.
Rick

 

[Van T. Dinh]

I am not entirely sure of the set-up you describe but:

1. DoCmd.Maximize

will maximise the active Form inside the current Access Application window.

2. DoCmd.RunCommand acCmdAppMaximize

will maximize the current Access Application window.