SizeMode Property [Access 2003 VBA Language Reference]

  • Article

You can use the SizeMode property to specify how to size a picture or other object in a bound object frame, an unbound object frame, or an image control.

expression.SizeMode

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

Remarks

The SizeMode property uses the following settings.

Setting Visual Basic Description
Clip acOLESizeClip (Default) Displays the object at actual size. If the object is larger than the control, its image is clipped on the right and bottom by the control's borders.
Stretch acOLESizeStretch Sizes the object to fill the control. This setting may distort the proportions of the object.
Zoom acOLESizeZoom Displays the entire object, resizing it as necessary without distorting the proportions of the object. This setting may leave extra space in the control if the control is resized.

Note  You can set the SizeMode property in a property sheet , in a macro , or by using 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.

Tip

Example

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 | Image Object | ObjectFrame Object

See Also | Action Property | Resize Event