ACC: Scroll Box Does Not Move Down Scroll Bar in Combo Box

• Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

When you are using a combo box on a form and the data source is a linked (attached) table, the scroll box does not always move down the scroll bar when you click the scroll arrow. Once you reach the bottom of the list, the scroll box works properly; it jumps to the bottom of the scroll bar, and then moves along as you scroll up and down the list.

CAUSE

When you click the scroll arrow to view the list, the combo box control does not always know how many records are in its control source table or query.

When you click the scroll arrow, Microsoft Access begins to read the data in the control source table or query. In order for the scroll box to move down the scroll bar, the combo box must know how many items are in the list so that it can calculate the correct physical location of the scroll box. For example, if you have 100 records in your table and you are viewing the 50th record in the list, the scroll box should appear halfway down the scroll bar.

Once you have scrolled down to the bottom of the list, the combo box knows the number of items included in the list. The scroll box now adjusts itself automatically, relative to any item in the list that you select.