Skip to content

Latest commit

 

History

History
64 lines (36 loc) · 2.66 KB

Access.Image.PictureType.md

File metadata and controls

64 lines (36 loc) · 2.66 KB
Raw
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Image.PictureType property (Access)
vbaac10.chm10367
vbaac10.chm10367
Access.Image.PictureType
873fdf85-bbd5-98d3-c8f0-4b1994ed0a85
03/05/2019
medium

Image.PictureType property (Access)

Use the PictureType property to specify whether Microsoft Access stores an object's picture as a linked or an embedded object. Read/write Byte.

Syntax

expression.PictureType

expression A variable that represents an Image object.

Remarks

The PictureType property uses the following settings.

Setting Value Meaning
Embedded (Default) 0 The picture is embedded in the object and becomes part of the database file.
Linked 1 The picture is linked to the object. Microsoft Access stores a pointer to the location of the picture on the disk.
Shared 2 The picture is linked to the object. Microsoft Access stores a pointer to the location of the picture within the database.

This property can be set only in form Design view or report Design view.

For controls, you can set the default for this property by using the default control style or the DefaultControl property in Visual Basic.

When this property is set to 0, the size of the database increases by the size of the picture file and, with some .wmf files, the size may increase as much as twice the size of the picture file. When this property is set to 1, there is no increase in the size of the database because Microsoft Access only saves a pointer to the picture's location on the disk. When this property is set to 2, the database size will increase for the first control that uses the picture, but will not increase if additional controls use the picture with this property value.

Note

If a linked file is moved to another location on the disk, you must re-establish the link by using the object's Picture property.

For embedded pictures, the object's PictureData property stores the individual bits that make up a picture's image. For linked pictures, this property stores the path to the picture's file.

You can modify a linked picture by using a separate application, and changes to the picture will appear the next time the object containing that picture is displayed in the database.

Example

The following example links the picture in the Customer Photo image control on the Order Entry form to the picture on the disk. The picture is not part of the database file.

Forms("Order Entry").Controls("Customer Photo").PictureType = 1

[!includeSupport and feedback]