OLETypeAllowed Property

Applies To

Bound Object Frame control, Chart control, Unbound Object Frame control.

Description

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

Setting

The OLETypeAllowed property uses the following settings.

Setting

Description

Constant

Linked

The control can contain only a linked object.

acOLELinked

Embedded

The control can contain only an embedded object.

acOLEEmbedded

Either

(Default) The control can contain either a linked or an embedded object.

acOLEEither


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 method 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.

Remarks

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

See Also

OLEType property.

Example

See the Action property example.

You can set the KeepTogether property for a group by using the Sorting And Grouping box, a macro, or Visual Basic.

In Visual Basic, you set the KeepTogether property for a group in report Design view or the Open event procedure of a report by using the GroupLevel property.

Remarks

To set the KeepTogether property for a group to a value other than No, you must set the GroupHeader or GroupFooter property or both to Yes for the selected field or expression.

A group includes the group header, detail section, and group footer. If you set the KeepTogether property for a group to Whole Group and the group is too large to fit on one page, Microsoft Access will ignore the setting for that group. Similarly, if you set this property to With First Detail and either the group header or detail record is too large to fit on one page, the setting will be ignored.

If the KeepTogether property for a section is set to No and the KeepTogether property for a group is set to Whole Group or With First Detail, the KeepTogether property setting for the section is ignored.

See Also

CreateGroupLevel function, GroupHeader, GroupFooter properties, GroupInterval property, GroupLevel property, GroupOn property, GrpKeepTogether property, KeepTogether property — sections, SortOrder property.

Example

See the GroupInterval property example.