Microsoft KB Archive/170987

From BetaArchive Wiki

Article ID: 170987

Article Last Modified on 1/20/2007


  • Microsoft Access 97 Standard Edition

This article was previously published under Q170987

Moderate: Requires basic macro, coding, and interoperability skills.


When you select multiple records in a continuous form and then copy and paste them, the first record pasted may appear to be blank. If you close and reopen the form, or if you scroll so that the record is no longer in view and then scroll back, the data in the record appears as expected.


There are three possible workarounds.

Method 1

Press F9 after pasting the records.

Method 2

On the Records menu, click Refresh.

Method 3

  1. Open the form in Design view.
  2. On the Edit menu, click Select Form.
  3. On the View menu, click Properties. Click the Event tab.
  4. Set the AfterInsert property of the form to the following event procedure:

    Private Sub Form_AfterInsert()
    End Sub


Microsoft has confirmed this to be a problem in Microsoft Access 97. This behavior does not occur in Microsoft Access 2.0, Microsoft Access 95, or Microsoft Access 2000.


Steps to Reproduce Problem

  1. Start Microsoft Access and open the sample database Northwind.mdb.
  2. Click the Forms tab in the Database window, and then click New.
  3. In the New Form dialog box, click Form Wizard and choose the Employees table. Click OK.
  4. Select LastName, FirstName, and BirthDate from the Available Fields list. Click Next.
  5. In the dialog box that asks you to choose a layout for your form, click Tabular; then, click Finish.
  6. When the form is open in Form view, select four records. You can do this by clicking the gray record selector to the left of the first record, then pressing SHIFT, and clicking the record selector to the left of the fourth record.
  7. On the Edit menu, click Copy.
  8. Click the record selector to the left of the new record at the bottom of the form.
  9. On the Edit menu, click Paste or Paste Append. When you see the message asking if you are sure you want to paste these records, click Yes.

Note that the first record pasted appears to be blank.


For more information about displaying the most current data in Form view, search the Help Index for "refreshing records."

Additional query words: empty

Keywords: kbbug kbui KB170987