ACC2000: Scroll Box Moves Up After Being Moved to the Bottom of the Scroll Bar (280133)
The information in this article applies to:
This article was previously published under Q280133 Moderate: Requires basic macro, coding, and interoperability skills.
This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).
SYMPTOMS
When you have a combo box or a list box on a form and the row source of the combo box or the list box is based on either a large table, query, or SQL statement or on a linked table, the scroll box on the combo box or the list 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 jumps to the bottom of the scroll bar.
CAUSE
When you first click the scroll arrow to view the list of a combo box or a list box, the control does not know how many records are in its row source.
RESOLUTION
Avoid using large tables (and other row sources) with combo boxes and list boxes that force end-users to have to scroll through more than 100 items. Good development and design encourages developers of a database application to find ways to limit the number of items displayed in a combo box or a list box.
The following Knowledge Base articles illustrate some methods that you can use to limit the number of items displayed in a combo box or a list box: 209576 ACC2000: How to Create Synchronized Combo Boxes
209595 ACC2000: How to Synchronize Two Combo Boxes on a Form
MORE INFORMATION
When you click the scroll arrow on a combo box or a list box, Access begins to read the data in the row source of the combo box or the list box. 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 the row source, and you are viewing the 50th record in the list, the scroll box should appear halfway down the scroll bar.
However, combo boxes and list boxes in Access do not become fully aware of how many records are in the row source until you have scrolled down to the bottom of the list. At that point, the scroll box will adjust itself
automatically, relative to any item in the list that you select.
| Modification Type: | Major | Last Reviewed: | 6/25/2004 |
|---|
| Keywords: | kbprb KB280133 |
|---|
|