Microsoft KB Archive/209706

= ACC2000: Unable to Paste Information into the Property Sheet =

Article ID: 209706

Article Last Modified on 7/15/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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.


 * 1) Select the entire SQL statement, and then click Copy on the Edit menu.
 * 2) Open the Orders form in Design view. If the property sheet is not open, click Properties on the View menu.
 * 3) Click the CustomerID combo box, and then select the Orders Qry in the property statement of the RowSource property.
 * 4) 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.
 * 1) Click Undo on the Edit menu.
 * 2) 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.
 * 1) Close the Orders form, and then click No if asked to save your changes.

