Getting All forms/queries/tables to show up full screen

[Jarad]

Is there a place I can insert a snippet of code to have all the forms come up full screen. Some users think it is annoying that they dont always come up maximized. Any help would be greatly appreciated!

 

[David Eagar]

Go to Macros - select New, choose Maximise and save the macro as autoexec
a small but very useful tip

 

[Jarad]

I got that, but dont know how to set it to autoexec. Which is why it isnt working I huh *haha*. So how do I set it to autoexec??

THANKS!!!

 

[Jarad]

nevermind, I read WAY to much into that D'oh!! I got it!! THANKS ALOT!

 

[David Eagar]

?? Not sure I follow? If you save the macro as 'autoexec' with 'maximise' as the action, it maximises all database forms etc on opening the database - or it has for mine for the past 10 years or so

 

[Dennisk]

if you double click the title part of any window in the access MDI then that window and all subsequent will be maximised or even easier click the maximise button on the top right of the window.

 

[MatMac]

Hi. Great tip - thanks.

One further question. I have saved an Autoexec Macro containing Maximise to run my forms maximised. My forms open further forms which must be closed before going back to the previous form. When closing some forms, the previous form returns to a non-maximised state. Why is this?

On the same subject. Is it possible, to set the contents of the form to sit directly in the middle of the form window, rather than at the top left corner?

Many thanks

Mat.

 

[Raven]

Go to Macros - select New, choose Maximise and save the macro as autoexec
a small but very useful tip

Too right - this is a well handy trick!

I've used this years ago on previous databases in another life, but I had forgotten all about it.

Thanks

 

[bbulla]

I find that putting DoCmd.Maximize in the forms OnActivate event seems to work best. That way regardless of wether you're opening it for the first time, or coming back ot it after opening another window, it is always maximized.

Also if you slap a DoCmd.Echo false before it, and a DoCmd.Echo true after it, you get rid of the annoying screen flicker that happens.

 

[MatMac]

This is really helpful. But I'm not there yet.

For most of my users, who have 800x600 screens, a maximised form is best. But for myself and a couple of others, with very high res displays, the objects in the maximised forms then sit in the top left corner of the screen, with a wash of blank space everywhere else.

It would be sooooo nice to somehow to group the form objects and set them to sit in the middle of the maximised form.

Any ideas??

M.

 

[bbulla]

Well, each control object has a 'Top' and 'Left' attribute, so you could adjust the position of each control according to the size of the maximized window. Of course, that would take a lot of code and logic to figure it out properly.

 

[chris davies]

well I've tried all of these to no avail, any further input please?

 

[DreamGenius]

I find that putting DoCmd.Maximize in the forms OnActivate event seems to work best. That way regardless of whether you're opening it for the first time, or coming back ot it after opening another window, it is always maximized.

Also if you slap a DoCmd.Echo false before it, and a DoCmd.Echo true after it, you get rid of the annoying screen flicker that happens.

I've been experiencing the same issue and read this answer with interest. Why does OnActivate work, while GotFocus, Load or Current don't?

I've tried the last three, all to no acceptable level of consistency, and I'm off to try this suggestion now.