Command Button Control, Form, Image Control, Report, Toggle Button Control.
You can use the PictureType property to specify whether Microsoft Access stores an object’s picture as a linked object or an embedded object.
The PictureType property uses the following settings.
Setting |
Description |
Visual Basic |
Embedded |
(Default) The picture is embedded in the object and becomes part of the database file. |
0 |
Linked |
The picture is linked to the object. Microsoft Access stores a pointer to the location of the picture on the disk. |
1 |
You can set the PictureType property in the object’s property sheet, a macro, or using Visual Basic.
This property can be set only in form or report Design view.
For controls, you can also set this property using the default control style.
When the PictureType property is set to Embedded, 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 the PictureType property is set to Linked, 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.
Note If a linked file is moved to another location on the disk, you must re-establish the link using the object’s Picture property.
The individual bits that make up a picture’s image are stored in the object’s PictureData property.
You can modify a linked picture using a separate application and changes to the picture will appear the next time the object containing that picture is displayed in the database.
Picture Property, PictureData Property.