Automatically Scroll or Page Down/Up

[Lamar]

I have form with alot of information for the user to enter. It has sections
of info on it.

So I want when a control gets the focus to automatically scroll down (the
scroll bar). So the whole section of info can be seen instead of user having
to manually scroll down or page down.

Can you use VB code to automatically scroll up and down a form? Thanks for
any help.

 

[Stephen Lebans]

You really should consider using a TAB control with multiple Pages to
display the required contents of your form.
With that being said, Access always automagically scrolls the form to view
the selected Control. Not sure why that is not the case with your form. Are
these TextBox controls we are talking about?
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Lamar]

It textbox controls. Yes, MS Access does automatically scroll down but that
is not my issue.

i.e. I have a billing section on my form. The first textbox of the billing
section is txtBasicCharge. When you tab to the txtBasicCharge only that
textbox is shown and not all the entire billing section. I would like the
whole billing section to show on screen. The user can scroll down but I want
it to scroll or page down as soon txtBasicCharge gets the focus.

 

[Stephen Lebans]

Without getting into code available on my site to directly manipulate the
ScrollBar I would suggest you try, in the GotFocus event of txtBasicCharge,
setting the focus to a TextBox control at the bottom of the page, then
immediately SetFocus back to the txtBasicCharge control.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.