ACC97: First Record of Multiple Pasted Records Appears Blank

• Microsoft Access 97

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

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.

RESOLUTION

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()
            Me.Refresh
         End Sub
   
   

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access 97. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available. This behavior does not occur in Microsoft Access version 2.0 or 95.

MORE INFORMATION

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.

REFERENCES

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