OLETypeAllowed Property [Access 2003 VBA Language Reference]

You can use the OLETypeAllowed property to specify the type of OLE object a control can contain. Read/write Byte.


expression Required. An expression that returns one of the objects in the Applies To list.


The OLETypeAllowed property uses the following settings.

Setting Constant Description
Linked acOLELinked The control can contain only a linked object.
Embedded acOLEEmbedded The control can contain only an embedded object.
Either acOLEEither (Default) The control can contain either a linked or an embedded object.

Note  You can set the OLETypeAllowed property by using the control's property sheet , a macro , or Visual Basic . You can set the default for this property by using a control's default control style or the DefaultControl property in Visual Basic.

Note   For unbound object frames and charts , you can't change the OLETypeAllowed setting after an object is created. For bound object frames, you can change the setting after the object is created. Changing the OLETypeAllowed property setting only affects new objects that you add to the control.

To determine the type of OLE object a control already contains, you can use the OLEType property.


The following example creates a linked OLE object using an unbound object frame named OLE1 and sizes the control to display the object's entire contents when the user clicks a command button.

Sub Command1_Click
    OLE1.Class = "Excel.Sheet"    ' Set class name.
    ' Specify type of object.
    OLE1.OLETypeAllowed = acOLELinked
    ' Specify source file.
    OLE1.SourceDoc = "C:\Excel\Oletext.xls"
    ' Specify data to create link to.
    OLE1.SourceItem = "R1C1:R5C5"
    ' Create linked object.
    OLE1.Action = acOLECreateLink
    ' Adjust control size.
    OLE1.SizeMode = acOLESizeZoom
End Sub

Applies to | BoundObjectFrame Object | ObjectFrame Object

See Also | OLEType Property