Form Horizontal Scroll

[gerrythefish]

Anyone know how to get the horizontal scroll position on a form

I have a form in datasheet view, with the record ID column frozen and users typically scroll to the right to see certain columns. Different users scroll to a different position.

I dont have the option to reduce the number of columns or create separate forms for different users, - they all need to see all the columns but typically a user scrolls horizontally to see a certain set of columns most of the time. I want to save that position for the next time they open the form. Any help?

 

[CJ_London]

don't think you can do that with the standard scrollbar, I'm not aware of any property you can capture to determine the scroll position.

This is a link to a possible solution

http://msdn.microsoft.com/en-us/library/office/gg278741(v=office.15).aspx

suggest you would make your datasheet a subform of a form in single form view and adapt the code accordingly.

Untested, but you can try using a gotocontrol or setfocus function in the load event if you know which control the user first looks at.

Another possibility is to train users to move columns into the order they want, then store the resulting column positions for the next time they use the form

 

[gerrythefish]

I couldn't find a way to read how far a user scrolled, so I added a menu for the user to select the furthest column they need to see after they scroll over. Now on form load I setfocus to that control.

Just need to train users to use it.