Center Pop Up Form

[gheyman]

I have a form, which I set to Yes. How do I get it to pop up in the center of the screen instead of Top/Left?

 

[SQUIDD]

hi

I use this on my userforms

Me.StartUpPosition = 0
Me.Top = Application.Top + 45
Me.Left = Application.Left + Application.Width - Me.Width - 400

dave

 

[gheyman]

?

Private Sub Form_Load()
Me.StartUpPosition = 0
Me.Top = Application.Top + 45
Me.Left = Application.Left + Application.Width - Me.Width - 400
End Sub

It doesn't like Me.StartUpPosition = 0

 

[SQUIDD]

hi

try this in you userform activate code, is it a userform?

 Top = Application.Top + 130
 Left = Application.Left + Application.Width - Width - 400

You need to adjust the positions accordingly to suit your needs

 

[gheyman]

Yes a user form

 

[Micron]

gheyman, you realize a 'userform' is an Excel form, not an Access form? I ask because as I mentioned elsewhere, you're in the Access part of the forum. The are not the same.
You can try the Docmd.MoveSize method.

PS: I have no idea what this means "which I set to Yes"

 

[welshgasman]

PS: I have no idea what this means "which I set to Yes"

I think the o/p means the PopUp property on the Other property tab?