Form opens in the center and we have to scroll up to go on the top of the form

[jinalpatel]

Hello!!!

I have an extra long form. When I open it, it opens in the middle of the form.I have to scroll up to access the fields written on the top of the form.
Why is that? Which property should I have to set so that the form does not open in the middle of the form?
Form's Autocentre property is set to No

[missinglinq]

Best guess is the first control in the Tab Order is in the middle of the form. Use something like this to always set focus on a control at the top of the form:

Private Sub Form_Current()
 ControlAtTopOfForm.SetFocus
End Sub

BTW, forms long enough to need to be scrolled are considered to be very user-unfriendly! You should consider using Tabbed Controls in these situations..

Linq ;0)>

[jinalpatel]

Thanks!! It worked..

[missinglinq]

Glad we could help!

Linq ;0)>

[NeoPa]

If you want to manage this in the form's design, then select a tabbable control (TextBox, ComboBox, ListBox, CommandButton, etc) and, using right-click, select Tab Order...

This will enable you to arrange the order graphically as you see fit. This is only available on Form controls.

[jinalpatel]

Thanks you Neo Pa. I will keep in mind because the project is already given to the customer.
Thanks much for giving an idea.

[NeoPa]

No worries Jinal.

I find that is something often overlooked, so I try to keep it properly maintained in all my databases.