J
JB
I am building a form that containes a collection of controls some of which
the user can scroll using a scroll bar control. The usual way to do this is
to reposition the scrollable controls to the left or right depending on the
value returned by the scroll bar. The problem is that Access won't allow
controls to be repositioned outside the defined area of the eg Detail
section. Moving controls to the right isn't a problem because I can make the
details section large and then stop moving the controls when they are out of
sight. Scrolling to the left however doesn't work because as soon as the
position of the control is calculated to be negative, Access throws an
exception. I had the thought that I could get around this problem if I could
initiate the form will all the controls prositioned beginning at an offset of
say 5" and then the controls would have room to be positioned to the left
until they were out of sight to the user. My problem is that I can't find a
way to open the form scrolled to the initial offset of 5". I tried just
setting the offset in design mode and saving the form but that doesn't work
because Access sets the scroll only far enought to show whichever control has
the initial focus. Any ideas?
the user can scroll using a scroll bar control. The usual way to do this is
to reposition the scrollable controls to the left or right depending on the
value returned by the scroll bar. The problem is that Access won't allow
controls to be repositioned outside the defined area of the eg Detail
section. Moving controls to the right isn't a problem because I can make the
details section large and then stop moving the controls when they are out of
sight. Scrolling to the left however doesn't work because as soon as the
position of the control is calculated to be negative, Access throws an
exception. I had the thought that I could get around this problem if I could
initiate the form will all the controls prositioned beginning at an offset of
say 5" and then the controls would have room to be positioned to the left
until they were out of sight to the user. My problem is that I can't find a
way to open the form scrolled to the initial offset of 5". I tried just
setting the offset in design mode and saving the form but that doesn't work
because Access sets the scroll only far enought to show whichever control has
the initial focus. Any ideas?