PRB: Scrolling Records Changes the Size of the Scroll Box

Article ID: Q138017
Creation Date: 10-OCT-1995
Revision Date: 19-SEP-1996

The information in this article applies to:

Microsoft Access version 7.0

SYMPTOMS

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

When you open a recordset in Datasheet view or Continuous Form view and scroll through the records, the scroll box increases in size.

CAUSE

Microsoft Access cannot size the scroll box properly until it knows how many records are in the recordset. When you scroll to the end of the recordset, Microsoft Access updates the scroll box to the appropriate size.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

Open the sample database Northwind.mdb.

Create a new query based on the Products table.

In the query grid, add the following fields:

      Query: Query1
      ------------------------------------------
      Type: Select Query

      Field: ProductID
         Table: Products
      Field: ProductName
         Table: Products
      Field: QuantityPerUnit
         Table: Products
         Criteria: Like "*jar*" OR Like "*box*"

Run the query. Note the size of the scroll box in the Query datasheet.
Click the scroll-down arrow to move through the recordset. Note that the scroll box increases in size as you near the last record.

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.