Maximising

  • Thread starter Thread starter Jonathan
  • Start date Start date
J

Jonathan

Hi

I have created my first database and I use a shortcut open
up the application and access a form (what is effectively
a home page).

I want this form to instantly appear Maximised on screen.

How can I do this?

Thanks in advance.

Jonathan
 
I have created my first database and I use a shortcut open
up the application and access a form (what is effectively
a home page).

I want this form to instantly appear Maximised on screen.

How can I do this?
Click to expand...

In the On Open event for the form, add code:

DoCmd.Maximize

Tom Lake
 
If you do that, ALL your forms (including the database container
window) will now be maximized.

What most people forget to tell you when giving this advice is that
when you close the form, you must Restore it and all your other
Accesss forms

So in the On Close Event of the form you have to add the code

DoCmd.Restore


Cheers
Brett




In the On Open event for the form, add code:

DoCmd.Maximize

Tom Lake
Click to expand...

Cheers,
Brett
 
Tom Lake said:
In the On Open event for the form, add code:

DoCmd.Maximize

Tom Lake
Click to expand...

What is the difference in using VB code to achieve this and a macro. Or what
is the difference generally between using VB and macros?
 
What is the difference in using VB code to achieve this and a macro. Or
what
is the difference generally between using VB and macros?
Click to expand...

For a simple command or linear sequence of commands, there's not much
difference I can see. When you have complex processes or conditions, VBA
wins out every time. Also, VBA is compiled whereas macros are interpreted
although I don't notice a difference in execution speed. I grew up
programming in BASIC from about 1970 onward so I usually use code since I'm
more comfortable with it.

Tom Lake
 
Back
Top