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.
- 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.
- On the Edit menu, click Copy.
- Switch to Microsoft Access.
- 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
- If the application that you're copying from supports OLE drag-and-drop editing, then you can drag selected information from that application to the Design view of a Microsoft Access form or report. When you do this, Microsoft Access creates an unbound object frame and inserts the selected information in the frame.
- You can adjust the size and proportions of the object after you paste it.
How?
- In many cases, you'll edit an unbound object from form or report Design view. If you want to be able to edit the object from Form view also, then set the Enabled property of the unbound object frame to Yes and the Locked property to No.