Microsoft KB Archive/103191

{|
 * width="100%"|

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