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.