Scroll Bars Missing

[tennisguy]

Hi. I have a form that does not display either the horizontal or vertical scroll bar. The Scrollbars property in the form's property sheet is set to both, so I was curious if there was something else I'm missing that would cause this. Not sure what other information to provide. The form is based off of a query, but I'm not sure that the record source should have anything to do with the design or form view.

I've opened this form on several different computers and different versions of Access and the same thing happens.

Thanks,
Michael

 

[tennisguy]

OK. I discovered that I had a macro running when the form opens that finds the first record with a certain value in a specific control. When I take the macro away from the form's OnOpen event, the scrollbars show up again. I'm using the FindRecord action in the macro with the FindFirst argument set to Yes. I can still browse records OK using the navigation buttons, but it just took my scrollbars away. Is there any way to prevent this from happening or a different strategy I can use to find the first record without using the FindRecord argument?

Thanks again,
Michael