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

Posted on 2010-01-11
Medium Priority
Last Modified: 2013-11-28
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







Question by:mytfein
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
LVL 18

Accepted Solution

Simon earned 2000 total points
ID: 26287635
set the 'size mode' property of the image containing objectframe to zoom (on the format tab of the properties sheet)

Author Comment

ID: 26287914
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.
LVL 18

Expert Comment

ID: 26291355
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.

Author Comment

ID: 26293173
thank you Simon,s

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question