mytfein
asked on
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
https://www.experts-exchange.com/questions/23937582/Turning-an-image-from-the-filesystem-into-a-thumbnail-VBA.html?sfQueryTermInfo=1+dll+imag+thumbnail
https://www.experts-exchange.com/questions/10301506/thumbnails.html?sfQueryTermInfo=1+dll+imag+thumbnail
https://www.experts-exchange.com/questions/10169194/Displaying-thumbnails.html?sfQueryTermInfo=1+dll+imag+thumbnail
https://www.experts-exchange.com/questions/10180913/thumbnails-how.html?sfQueryTermInfo=1+dll+imag+thumbnail
https://www.experts-exchange.com/questions/10222336/Creating-Thumbnails.html?sfQueryTermInfo=1+dll+imag+thumbnail
https://www.experts-exchange.com/questions/11449059/JPEG-Image-Thumbnail-Creation.html?sfQueryTermInfo=1+dll+imag+thumbnail
2010-01-10-column-pictures6.GIF
a-testColumnPictures.mdb
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
https://www.experts-exchange.com/questions/23937582/Turning-an-image-from-the-filesystem-into-a-thumbnail-VBA.html?sfQueryTermInfo=1+dll+imag+thumbnail
https://www.experts-exchange.com/questions/10301506/thumbnails.html?sfQueryTermInfo=1+dll+imag+thumbnail
https://www.experts-exchange.com/questions/10169194/Displaying-thumbnails.html?sfQueryTermInfo=1+dll+imag+thumbnail
https://www.experts-exchange.com/questions/10180913/thumbnails-how.html?sfQueryTermInfo=1+dll+imag+thumbnail
https://www.experts-exchange.com/questions/10222336/Creating-Thumbnails.html?sfQueryTermInfo=1+dll+imag+thumbnail
https://www.experts-exchange.com/questions/11449059/JPEG-Image-Thumbnail-Creation.html?sfQueryTermInfo=1+dll+imag+thumbnail
2010-01-10-column-pictures6.GIF
a-testColumnPictures.mdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
ASKER
thank you Simon,s
ASKER
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.
2010-01-10-column-pictures8-zoom.GIF