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

Article translations Article translations
Article ID: 88656 - View products that this article applies to.
This article was previously published under Q88656
This article has been archived. It is offered "as is" and will no longer be updated.
Novice: Requires knowledge of the user interface on single-user computers.

Expand all | Collapse all

Symptoms

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, however, 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.

Properties

Article ID: 88656 - Last Review: October 26, 2013 - Revision: 3.0
Applies to
  • Microsoft Access 1.0 Standard Edition
  • Microsoft Access 1.1 Standard Edition
  • Microsoft Access 2.0 Standard Edition
  • Microsoft Access 97 Standard Edition
Keywords: 
kbnosurvey kbarchive kbprb kbusage KB88656

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com