About pasting data from another application - Access

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this link

Printer-Friendly Version Bookmark and Share

About pasting data from another application

Applies to: Microsoft Office Access 2003

When you copy a selection from another application to a form or report in Microsoft Access and click Paste Special on the Edit menu, Microsoft Access displays the Paste Special dialog box. The following table describes the options in the As list in the Paste Special dialog box.

Click this option in the As box	If you want to
*Application name* (for example, Microsoft Excel Worksheet)	Display the object in an unbound object frame (unbound object frame: A control that you place on a form or report to contain an unbound object. An unbound object is an object, such as a picture, whose value isn't derived from data stored in a table.). You can edit the object directly from the form or report if you click this entry.
Picture or Bitmap	Display the object in an image control (image control: A control that is used to display a picture on a form, report, or data access page.). Click one of these entries if you want to optimize the performance of your form or report. You can't edit the object from the form or report if you click one of these entries.
Text	Display the text that you copy (for example, the text in a Microsoft Excel cell) in a label if the object is inserted (embed: To insert a copy of an OLE object from another application. The source of the object, called the OLE server, can be any application that supports object linking and embedding. Changes to an embedded object are not reflected in the original object.), or a text box if the object is linked (OLE/DDE link: A connection between an OLE object and its OLE server, or between a Dynamic Data Exchange (DDE) source document and a destination document.). When you link a text box this way, Microsoft Access creates a DDE (Dynamic Data Exchange (DDE): An established protocol for exchanging data between Microsoft Windows-based programs.) link in the text box. When you switch to Form view (Form view: A window that displays a form to show or accept data. Form view is the primary means of adding and modifying data in tables. You can also change the design of a form in this view.) or Print Preview, you'll see the actual linked text.