Unbound Object Frame Control.
You can use the Item property to get a description of the linked data displayed in a unbound object frame.
The Item property setting is a string expression and is read-only in all views.
The description of a linked object frame depends on the kind of OLE object it is linked to. For example, if you link it to cells in a Microsoft Excel worksheet, Microsoft Access displays the cell data in the object frame, and the Item property identifies the linked cells using the row-and-column format. For a chart, the Item property setting is the word “Chart”. For a graphic, the setting is the coordinates of the linked graphic area.
Note The data for a linked OLE object is displayed in the frame but is stored by the application that created the data. To change the data, you must use that application.
When you link an OLE object to an object frame using the Paste Special command on the Edit menu, Microsoft Access sets the SourceObject, OLEClass, and Item properties. The following table shows typical property settings for various OLE objects.
|
Object |
SourceObject property |
OLEClass property |
Item property |
|
Worksheet |
C:\Excel\Xls\Mywrksht.xls |
Microsoft Excel Worksheet |
R1C1:R7C4 |
|
Chart |
C:\Excel\Xls\Mychart.xlc |
Microsoft Excel Chart |
Chart |
|
Graphic |
C:\Windows\Mybitmap.bmp |
Paintbrush Picture |
0 0 72 71 |
Action Property, OLEType Property.