Item Property (ObjectFrame Control)

Item Property (ObjectFrame Control)

See Also                  Applies To

You can use the Item property to get a description of the linked data displayed in a chart control or unbound object frame.

Setting

The Item property setting is a string expression and is read-only in all views.

Note   If you are using Automation (formerly called OLE Automation), and need to specify a range of data, use the SourceItem property.

Remarks

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 unbound object frame by clicking Paste Special 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