Force Database Window Size

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, everyone!

Is there any way (Database settings, VBA code, macro, etc.) to force an A2K
database window to be a certain size when the database is opened? This
would, preferably, not affect the size of a different .mdb when it is opened.

Thanks,
Bruce
 
BruceS said:
Is there any way (Database settings, VBA code, macro, etc.) to force an A2K
database window to be a certain size when the database is opened? This
would, preferably, not affect the size of a different .mdb when it is opened.
Click to expand...

Use the MoveSize action in your AutoExec macro.
 
Sorry, Marsh, but that's not the result I want. What I was shooting for was
to set the size of the MS Access application window.

What I had: "Splash" form set to load in the Startup Options. AutoExec
macro with only MoveSize command.
Result: "Splash" opens at startup, then resizes to specs in MoveSize.
(Size of Access "container" window did not change.)

What I tried: Removed "Splash" from Startup Options and put in an OpenForm
for it following the MoveSize in the AutoExec macro.
Result: Macro error. Guessing that it happens because there's no form open
at the time the MoveSize is called.

Any way to set the size of the MS Access application "container" window at
start up? Don't care if they drag the corner to re-size after it starts, but
I'd like the app to come up looking it's best.

Thanks,
Bruce

Bruce
 
Marsh,
Thanks for the help!
Bruce

Marshall Barton said:
Sorry, I thought you were asking about the Database window.

The Access window is controled by Windows and would need to
be manipulated by Windows API code. See
http://www.mvps.org/access/api/api0019.htm
--
Marsh
MVP [MS Access]

Sorry, Marsh, but that's not the result I want. What I was shooting for was
to set the size of the MS Access application window.

What I had: "Splash" form set to load in the Startup Options. AutoExec
macro with only MoveSize command.
Result: "Splash" opens at startup, then resizes to specs in MoveSize.
(Size of Access "container" window did not change.)

What I tried: Removed "Splash" from Startup Options and put in an OpenForm
for it following the MoveSize in the AutoExec macro.
Result: Macro error. Guessing that it happens because there's no form open
at the time the MoveSize is called.

Any way to set the size of the MS Access application "container" window at
start up? Don't care if they drag the corner to re-size after it starts, but
I'd like the app to come up looking it's best.
Click to expand...
Click to expand...
 
Back
Top