ACC2000: Unable to Paste Information into the Property Sheet (209706)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q209706
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SYMPTOMS

You are unable to paste information into a property sheet by using the Paste command on the Edit menu. Instead, you create a new label control on your form or report.

CAUSE

This behavior occurs because menu commands do not apply to pop-up windows.

RESOLUTION

Use equivalent keyboard actions rather than selecting commands from the Microsoft Access menu bar. In this case, use CTRL+V or SHIFT+INSERT to paste information into a pop-up window.

MORE INFORMATION

Property sheets are actually pop-up windows. When you use menu commands, Microsoft Access returns focus (from the pop-up window) to the parent window. When you use equivalent keyboard actions, Access retains focus on the current edit control (in this case the property sheet). Therefore, by selecting the Paste command from the Edit menu, you paste a new label in the parent form, or Report window.

Steps to Reproduce Behavior

  1. Start Microsoft Access and open the sample database Northwind.mdb.
  2. Open the Customers and Suppliers by City query in Design view. NOTE: In Microsoft Access project (.adp), open the Customers and Suppliers by City query in Design view. On the View menu select Show Panes, and then click SQL.

  3. Select the entire SQL statement, and then click Copy on the Edit menu.
  4. Open the Orders form in Design view. If the property sheet is not open, click Properties on the View menu.
  5. Click the CustomerID combo box, and then select the Orders Qry in the property statement of the RowSource property.
  6. Try to paste the SQL code into the RowSource property by clicking Paste on the Edit menu.

    Note that Microsoft Access creates a new label on the form that contains the SQL statement.
  7. Click Undo on the Edit menu.
  8. Select the Orders Qry in the RowSource property statement, and then use CTRL+V or SHIFT+INSERT.

    Notice that the SQL statement from the clipboard is pasted into the property sheet.
  9. Close the Orders form, and then click No if asked to save your changes.

REFERENCES

For more information about keyboard shortcuts in Microsoft Access, click Microsoft Access Help on the Help menu, type keyboard shortcuts in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

For more information about creating pop-up forms, click Microsoft Access Help on the Help menu, type create a pop-up form in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
Modification Type:MinorLast Reviewed:7/15/2004
Keywords:kbprb kbusage KB209706
©2004 Microsoft Corporation. All rights reserved.