Discussion Locked

Inserting Images in MS Access

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
The HR Department in the city I work at recently created an Access Database to input employee information.They want to be able to print ID cards for employees.The problem we are having is everytime we insert the picture the image is to big.I was wondering if anybody new if I could control the size of the image within Access or is that something I have to control within the camera? All pictures are JPEG's

3 replies

by dklippert

When you create your Form or Report to build the ID card the picture should be in a Bound Object Frame.
In the Properties of that frame, you can set the size (Width and Height) on the Format tab. Next in the Size Mode field on the Format tab chooseStretch or Zoom.
Try both. Stretch will size the picture to fit the control, but there could be distortion. Zoom will size the picture to fit without distortion, but may leave extra space if the control is resized.

This discussion is closed to new replies.