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 |
See Also OLEClass property, OLEType property, SourceItem property, SourceObject property.