Microsoft KB Archive/138017

{|
 * width="100%"|

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." '' ©1997 Microsoft Corporation. All rights reserved. Legal Notices.

''

Additional reference words: 7.00

KBCategory: kbui

KBSubcategory: UiDatash