Report.PictureSizeMode property (Access)
Use the PictureSizeMode property to specify how a picture for a form or report is sized. Read/write Byte.
Syntax
expression.PictureSizeMode
expression A variable that represents a Report object.
Remarks
The PictureSizeMode property uses the following settings.
| Setting | Visual Basic | Description |
|---|---|---|
| Clip | 0 | (Default) The picture is displayed in its actual size. If the picture is larger than the form or report, the picture is clipped. |
| Stretch | 1 | The picture is stretched horizontally and vertically to fill the entire form, even if its original ratio of height to width is distorted. |
| Zoom | 3 | The picture is enlarged to the maximum extent possible while keeping its original ratio of height to width. |
| Stretch Horizontal | 4 | The picture is stretched horizontally to fit the width of the form. |
| Stretch Vertical | 5 | The picture is stretched vertically to fit the height of the form. |
When a small picture is used for the Picture property of a form or report, setting the PictureSizeMode property to Stretch or Zoom can cause substantial distortion of its resolution. Smaller pictures can be tiled across the entire form or report by using the PictureTiling property.
Example
The following example sets the background picture of the Order Entry form to "Contacts.gif", and stretches the picture to fit the entire form's background.
With Forms("Order Entry")
.Picture = "C:\Picture Files\Contacts.gif"
.PictureSizeMode = 1
End With
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.