Maximise Form on load

[Lateral]

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]

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:

Sub MainForm_Load()

DoCmd.Maximize

End Sub

 

[Lateral]

Perfect!!!!

Thanks Alan.

 

[paramesium]

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:

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]

I realise I have to set windows pop up property to "Yes".

Now I got it =)