Insert part of an existing unbound object on a form or report

Insert part of an existing unbound object on a form or report

You can use this procedure if the application that you're copying from has OLE support for copying part of an existing document.

  1. Open the file in the application that you used to create it, and select the information you want to insert. For example, open Microsoft Excel and select a range of cells.

  2. On the Edit menu, click Copy.

  3. Switch to Microsoft Access.

  4. In form Design view or report Design view, click Paste on the toolbar.

Microsoft Access creates an unbound object frame, and displays the object in the frame. If you want to edit the object, then double-click it.

Note   If you want to display the object as an icon or if you want to specify what type of object to paste as, then click Paste Special on the Edit menu. For information on Paste Special options, click .

Notes