Force Access Window Size...

[rocketship]

Hey guys, I know this question gets asked here frequently and I know the best
place to go for this is...

http://support.microsoft.com/kb/210085

however when I follow those instructions to a tee, it never works when I
reopen the database. For exemple I setup my module, I insert the code, then
I insert the ?SizeAccess(0,0,480,640) into the immediate window, press enter
and it works then. Lets say I save my module, I maximize the window, close
access, when I reopen access it goes back to the maximized size.

Any idea what gives? I have been browsing the forums for hours trying to
figure this out. Thanks for your help!!!

 

[Guest]

you need to call the SizeAccess function when you open the database for it to
resize the window. In the onload code of your startup form place:

SizeAccess 0, 0, 480, 640

 

[rocketship via AccessMonster.com]

Ok, im kinda of a newb, so please forgive me.

First off, thank you, that worked! However...

When I right click on the form and click "Build Event" if I build the event
through code builder, it will not let me go back through and add a macro to
maximize the form. If I build the even through code builder, it will not
allow me to put a macro on the form so when it loads, it loads the macro. Im
not sure how I can add the macro to load and the code to load at the same
time...

Thank you again...

you need to call the SizeAccess function when you open the database for it to
resize the window. In the onload code of your startup form place:

SizeAccess 0, 0, 480, 640

Hey guys, I know this question gets asked here frequently and I know the best
place to go for this is...

[quoted text clipped - 9 lines]

Any idea what gives? I have been browsing the forums for hours trying to
figure this out. Thanks for your help!!!

 

[rocketship via AccessMonster.com]

Never mind! I found it! DoCmd.Maximize is my friend! haha. Thank you for
your help again man, you nailed it! Thanks!

Ok, im kinda of a newb, so please forgive me.

First off, thank you, that worked! However...

When I right click on the form and click "Build Event" if I build the event
through code builder, it will not let me go back through and add a macro to
maximize the form. If I build the even through code builder, it will not
allow me to put a macro on the form so when it loads, it loads the macro. Im
not sure how I can add the macro to load and the code to load at the same
time...

Thank you again...

you need to call the SizeAccess function when you open the database for it to
resize the window. In the onload code of your startup form place:

[quoted text clipped - 6 lines]