Thread: Maximise a Userform in Window

Hi
Every time I Open my userform in access (by clicking on the forms shorcut) the window opens and the userform appears in a no quiet maximised state. I have to click on the maximise symbol on the top right corner to make it fit the window.

Is there any setting or property which will automatically maximise the form to the size of the window. I can use a macro which works fine though there must be a standard way of doing this.

Thanks
Danny2000

I just created a UserForm for a test. I put the width and height dimensions in the initialize event like this:

Code:

Private Sub UserForm_Initialize()
With UserForm1
.Width = 640
.Height = 480
End With
End Sub

Then in the VBA module I use:

Code:

Sub UFtst()
UserForm1.Show(Modal)
MsgBox "Check Size"
Unload UserForm1
End Sub

It brings the form up in the larger dimension, which indicates that you can set it to fit your full screen size.

Hi danny2000,

Insert this code in your form's code window:

Code:

 
Private Sub Form_Open(Cancel As Integer)
     DoCmd.Maximize
End Sub

Cheers,