Moving a scroll bar with VBA

[Guest]

Hello,

I'm using Access 2003. I have a form with a tab control and a horizontal
scroll bar. One of the tabs is very wide, and scrolling far to the right is
necessary to see all of the data. I don't mind this, but when I click on
this particular tab, the scroll bar automatically shoots way out to the
right, and it's not very user-friendly.

Is there a way to force the horizontal scroll bar all the way to the left
when this tab is clicked?

Thanks,

Scott

 

[Guest]

I don't know if it is possible to set the scrollbar to a specific position. I
know you can set the visible or not. But could it be that a certain field is
getting focus when you click on the tab? Maybe if the first field of that tab
gets the focus the scrollbar doesn't move to the right anymore.

 

[Guest]

Maurice,

That helped, thanks. It was focusing on a field in the middle of the tab.
It would be better if it could scroll all the way to the left, as some lables
are still not in the visible window, but setting focus to the left-most field
is much better.

Thank you.

-Scott