Attachment.PictureSizeMode property (Access)

Use the PictureSizeMode property to specify how a picture for an attachment control is sized. Read/write Byte.

Syntax

expression.PictureSizeMode

expression A variable that represents an Attachment 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 attachment control, the picture is clipped.
Stretch 1 The picture is stretched horizontally and vertically to fill the entire attachment control, 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.

When a small picture is used for the DefaultPicture property of an attachment control, setting the PictureSizeMode property to Stretch or Zoom can cause substantial distortion of its resolution. Smaller pictures can be tiled across the entire attachment control by using the PictureTiling property.

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.