keep a form from bouncing to the left

[normajean]

Hi there:
I have a fairly wide form (more fields than will fit into the screen width), so you have to scroll over to the right to see the righthand fields.
If I scroll over to the right, based on the value in those fields, I see a range of records I want to select (and I want to do the selection by using the record selectors which are displayed at the lefthand side of the scolled screen).
My problem is that when I click on the record selectors, the form display jumps to the left. This means that the field that was being used for selection criteria is no longer in view, and that user doesn't know which records they want to select anymore.

Is there some kind of property that can tell the form to 'stay put' until the scroll bar is manually moved, no matter what happens?

The same behavior is also happening when the Record Source of the form is changed - (i.e. sort or filter based on values in a field on the right side of the scrolled form). The user wants to keep viewing the fields on the right hand side of form, but has to scroll back over after the RecordSource update.

Thanks for any insight you can provide!! Normajean

 

[ColinEssex]

You might be better off using tabs on the form and breaking up the fields into "categories" then the form will fit the page ok.

Col

 

[browntrout]

Just a thought (may not fit your situation at all).

Have you considered displaying your form as a subform (datasheet view)?

This would allow you to have record selectors and you could lock, say, the first column. This would ensure that when your users scrolled to the right, the record selectors and the first column would always be displayed ... But the field for selection would also still be in view.

 

[PaddyIrishMan]

The alternative is to SetFocus on a field to the right of your form after clicking on your record selectors.

I personally would go with tabs though as ColinEssex suggested.