• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 598
  • Last Modified:

Access 2003: Scaling an image to the size of an image control on a report

Hi EE,

In an earlier post today, i posted to discuss creating a report with columns. 4 by 4 columns. each column has
a students picture, underneath pic.is name, underneath name is email.

i learned from EE today, how to retrieve image file from external folder. that works.

I'd like the image to scale to see the complete picture, (full headshot) in the 1.2 inc. by 1.2 inch dimensions.
Below, have pasted various EE links.

What would the easiest approach be. Do you have sample mdb, that I can learn from?
I found these links a little sophisticated for me... perhaps with a little hand holding i could understand it....

p.s. unable to post sample image files of students due to privacy laws.....

tx in advance, sandra   below are links







  • 2
  • 2
1 Solution
set the 'size mode' property of the image containing objectframe to zoom (on the format tab of the properties sheet)
mytfeinAuthor Commented:
Hi Simon,

Thx sooooo much for writing!  A tremendous improvement!

Just wondering,
a) if you know what the choices
        clip (that's what it was set to), zoom, stretch mean?

b) pls see the screen shot below, now you see the whole flower scenery, but there is white
     space around it. (The flower scenery i set as the default picture value, but in vba , it is overridden
     using the actual student's picture.)  Should i worry about the white.... the report results are fine.
1. Clip means show a portion of the picture at full size, regardless of whether it all fits.
Zoom means scale the picture, maintaining proportions to fit the box (what you'd usually want for photos)
stretch means scale the picture independsently in each direction, not preserving aspect ratio (what you might do with a background image)

2. You are getting white space above and below your photo simply because the aspect ratio of the photo doesn't match the aspect ratio of your objectframe. It shouldn't matter on the report if all the photos are the same size. If you want to make them fit exactly, size your objectframe to be in the same ratio as your photos e.g. 4x3.
mytfeinAuthor Commented:
thank you Simon,s

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now