Distorted Image Access Report

Question

When I developed Access Report, image wasn't clear and after many attempts and research, I changed "Picture Property Storage Format" after setting Picture Property and Embed and Stretched. Now some users started getting reports with images, and then I changed image property to Linked and Stretched. But now again my images are getting distorted.

Answer 1

"This setting may leave extra space in the control if the control is resized."" true Daniel, I wanted to fill the control, else it wont look good. Another issue of missing images were high resolution of images. I made sure all image are 6**x4**, it working perfectly fine. Thanks for your prompt response.

Answer 2

Making "Zoom" will make ur images magnified. I kept it as Stretched and Linked. The reason few images were missing is because of the load that system was taking for generating report, it use to have 200-300 pages per report.  Now its working fine.

Answer 3

I agree with Tom.  If you look at the help, https://msdn.microsoft.com/en-us/vba/access-vba/articles/image-sizemode-property-access , you'll see that

Stretch = "Sizes the object to fill the control. This setting may distortthe proportions of the object."

and as Tom suggested

Zoom = "Displays the entire object, resizing it as necessary without distorting the proportions of the object. This setting may leave extra space in the control if the control is resized."

Answer 4

Isn't that to be expected if you choose Stretched? The image will grow to the size of the box. Check the help page on the SizeMode property. Maybe "Zoom" makes more sense for your needs.