Maximise Form on load (2 Viewers)

Lateral

Registered User.
Local time
Today, 13:44
Joined
Aug 28, 2013
Messages
388
Hi guys

I'm a newbie using Access 2007.

I am trying to make things as easy as possible for the user of a database that I have been working on.

The users maximum screen resolution is 1600 x 900 and I want to have specific forms automatically "maximise" to fit the screen.

I have set the Form property "Fit to Screen=Yes" but it does not do what I am expecting and want.

I also have "Auto Resize=Yes"

Any help is appreciated.

Regards
Greg
 

Alansidman

AWF VIP
Local time
Today, 15:44
Joined
Jul 31, 2008
Messages
1,493
To maximize an Access form automatically, use the "Maximize" method of the DoCmd Object.

Example, let's say I have a form called MainForm, on the "On Load" Event property of the form, I would use this sub procedure:

Code:
Sub MainForm_Load()

DoCmd.Maximize

End Sub
 

Lateral

Registered User.
Local time
Today, 13:44
Joined
Aug 28, 2013
Messages
388
Perfect!!!!

Thanks Alan.
 

paramesium

Registered User.
Local time
Today, 13:44
Joined
Oct 23, 2013
Messages
15
To maximize an Access form automatically, use the "Maximize" method of the DoCmd Object.

Example, let's say I have a form called MainForm, on the "On Load" Event property of the form, I would use this sub procedure:

Code:
Sub MainForm_Load()

DoCmd.Maximize

End Sub

Hi Alan, I did this using docmd.minimize on my file, but it doesnt seem to work, do you have any idea how to solve this problem?
 

paramesium

Registered User.
Local time
Today, 13:44
Joined
Oct 23, 2013
Messages
15
I realise I have to set windows pop up property to "Yes".

Now I got it =)
 

Users who are viewing this thread

Top Bottom