Tabbing - Form Scrolling

[RJW]

I've searched and haven't seen this particular question asked and answered before. Sorry if was and I missed it.

I create my forms so that the user entering the data can use the tab key to move through the entire form and hopefully never touch the mouse. And I have forms that are longer than what the screen resolution can display.

When they get to bottom of the form and tab to the next field, which is currently not visible, the form scrolls up to display the next field at the very bottom of the form.

When this happens, I would like the form to scroll a bit further so that when the next field becomes visible it's not at very bottom of the form, but a little higher.

Is this possible?

Thanks for your time and support.

 

[Moniker]

In Access Help, search on Scroll Method and select the returned entry "Scroll Method (Forms)".

 

[unclejoe]

Hi,

Insert a PageBreak from the Toolbox menu.

Put the control just after the last tab control and the the last control’s LostFocus Event key in this

Me.GoToPage 2

I've searched and haven't seen this particular question asked and answered before. Sorry if was and I missed it.

I create my forms so that the user entering the data can use the tab key to move through the entire form and hopefully never touch the mouse. And I have forms that are longer than what the screen resolution can display.

When they get to bottom of the form and tab to the next field, which is currently not visible, the form scrolls up to display the next field at the very bottom of the form.

When this happens, I would like the form to scroll a bit further so that when the next field becomes visible it's not at very bottom of the form, but a little higher.

Is this possible?

Thanks for your time and support.

 

[RJW]

Thanks for the help Moniker & unclejoe,

A search on "Scroll Method" in Access 2003 didn't return "Scroll Method (Forms)". At least not that I saw.

The PageBreak worked.

Thanks for the replies and the help.