Microsoft KB Archive/94218

= ACC: Unable to Paste Information into Property Sheet =

Article ID: 94218

Article Last Modified on 1/18/2007

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q94218



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



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



CAUSE
You are using menu commands that 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.



STATUS
This behavior is by design.



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, Microsoft Access retains focus on the current edit control (in this case the property sheet). Therefore, selecting the Paste command from the Edit menu will paste a new label in the &quot;parent&quot; Form or Report window.

Steps to Reproduce Behavior

 * 1) In the sample database Northwind.mdb (or NWIND.MDB in versions 1.x and 2.0), open the &quot;Customers And Suppliers By City&quot; query (or &quot;Customer List&quot; query in versions 1.x and 2.0) in Design view.
 * 2) Select the entire SQL statement and click Copy on the Edit menu.
 * 3) Open the Orders form in Design view. If the property sheet is not open, click Properties on the View menu.
 * 4) Click the CustomerID combo box, and then select the entire RowSource property statement in the property sheet.

NOTE: In versions 1.x and 2.0, there is a space in the Customer ID field.
 * 1) 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 containing the SQL statement.
 * 2) Click Undo on the Edit menu. Close the Orders form and click No if asked to save changes.

NOTE: If you use CTRL+V or SHIFT+INSERT, Microsoft Access pastes the information from the Clipboard into the property sheet.

