Make labels always visible as user scrolls right

[Guest]

I am designing my forms to fit 600 x 800 resolution. I have more horizontal
real estate on the form than the screen size can show, therefore my user will
have to use the horizontal scroll bar to move left to right on the form. My
problem is that I want the left most controls (which are labels) to always be
visible as my user scrolls to the right. (The concept would be similar to
"freezing panes" in Excel) This will be helpful to ensure the user is putting
the right data in the right text boxes. I am struggling with a clean
solution for this....any ideas. I hope I am missing something simple........

Thanks for your help,
Chace

 

[Kevin R]

Make a new form containing your form as a subform,
then on the new form (the parent form) you can put labels
next to each row and the horizontal scrollbar on the subform
wont affect the lables.

Kevin R

 

[Guest]

Good idea. I will give that a try too. As I was searching for similar
issues I found Leban's code that returns the scroll bar position. Then I
assigned the .Left property of the Labels I wanted to move to the scroll bar
position and it works pretty good. it updates on the form timer event every
250msec.

Your way is probably better......and shouldn't take much effort. Thanks
for the idea.

Chace