Control of horizontal scroll bar

[smthomer]

Hello All:



I am working on a searchable form (left side is for entering criteria and right side is for displaying records matching criteria). The width of the form currently exceeds my screen so I see a horizontal scrollbar on the bottom. I would like to add a command button that when clicked will cause the scrollbar to move to the right. Can anyone assist?

[weekend00]

You can click on the right blank area of the bar to go to right. same of left.
Button is not needed.

[smthomer]

There will be multiple users for my database. If I can use a command button, it would be more intuitive.

[weekend00]

If your user have been using computer, they must know how to scroll the bar better than remember one more button to do this.

If they have never used a computer, it's better to teach them this little skill. general skill can be use any where while you button works only for you form.

Anyway, if you still want a button, here it is:
assume RightControlName is the name of the most right side control,
LeftControlName is the name of the most left side control,
then click button CommandGoToRight will scroll the window to the right,
click button CommandGoToLeft will scroll the window to the left

Private Sub CommandGoToRight_Click()
RightControlName.SetFocus
End Sub
Private Sub CommandGoToLeft_Click()
LeftControlName.SetFocus
End Sub