ACC97: First Record of Multiple Pasted Records Appears Blank

Last reviewed: July 8, 1997
Article ID: Q170987
The information in this article applies to:
  • 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."


Additional query words: empty
Keywords : kbui
Version : 97
Platform : WINDOWS
Hardware : x86
Issue type : kbbug
Resolution Type : kbworkaround


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.

Last reviewed: July 8, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.