Image.SizeMode property (Access)
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.
Syntax
expression.SizeMode
expression A variable that represents an Image object.
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. |
Use the Clip setting for the fastest display. Use the Stretch setting for bar graphs and line graphs without concern for size adjustments. The Stretch setting can distort circles and photos.
Example
The following example creates a linked OLE object by using an unbound object frame named OLE1, and sizes the control to display the object's entire contents when the user chooses 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
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for