Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/103191

From BetaArchive Wiki

PRA: Slow Repaint When Saving Form with Many Controls

Article ID: Q103191
Creation Date: 18-AUG-1993
Revision Date: 19-SEP-1996 The information in this article applies to:

  • Microsoft Access version 1.0

SYMPTOMS


The first time you save a form that contains both a large number of controls and a counter field, Microsoft Access repaints the controls one at a time. This process may take 2 to 10 seconds, depending on the speed of your processor.

CAUSE


Because the form contains a counter field, it must be repainted when the counter value is determined (the first time the record is saved). All fields on the form are repainted, not only the counter.

STATUS


Microsoft has confirmed this to be a problem in Microsoft Access version 1.0. This problem no longer occurs in Microsoft Access version 1.1.

MORE INFORMATION


Steps to Reproduce Problem


  1. Create a table with a counter field and approximately 100 fields with the Yes/No data type.
  2. Create a new form based on the above table and include all fields.
  3. Add the Yes/No fields to the form as check boxes.
  4. Open the form and select a majority of the check boxes. When you save the record, the drive light flashes momentarily as each record is saved. Microsoft Access then takes several seconds to update the display.

NOTE: This problem occurs only the first time the record is saved. Subsequent changes to the record do not cause this behavior.



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: 1.00 forms update counter paint refresh
KBCategory: kbusage
KBSubcategory: FmsRqry