How to scroll MS-Access form with VBA

[hstijnen]

Hi,
I've a form in MS-Access that opens with the vertical scroll position not on top of the form. What can I do to make scroll position on top when I start the form?

Thanks for help

Henk

 

[PHV]

Which control has the focus when the form is opened ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[hstijnen]

I've a mainform which contains a tabcontrol with several tabs. On every tab there is a subform. The form opens on the first tab. The uppermost control has focus. This control is rather on top of the window, so that the tabs of the tabcontrol aren't visible. And I have to scroll up to see them.
Now I'm looking for a piece of VBA to do that in the Form_Open

 

[PHV]

to do that in the Form_Open
Better in the Form_Load

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[hstijnen]

Thanks,
but I'm looking for the VBA code or some other trick...