Item Property (ObjectFrame Control)

Applies To

Chart control, Unbound Object Frame control.

Description

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