Image Size in an mdb

[Guest]

Hi.

Im having strange problems sizing images which I link to a bound OLE Object
field. Heres whats happening. I take a digital picture at the smallest
setting and store it in a folder. Then I link to it from my form (access 2002
on XP). The image shows but its far too large. So I double click on the image
and open it in Ms Photo Editor. Here I find I have to resize it to 1.88cm
high by 1.42 cm wide in order for it to fit in the form window which is
approx 5.55. cm high by 4.455 cm wide. A Report prints the images at this
larger size also. When I print directly from Photo Editor I get the correct
sized (1.88 X 1.42) tiny thumbnail picture.

Why do the dimensions not tie up? All dimensions seem to be in cms.

Thanks for any help, JohnB

 

[Larry Linson]

Check the PictureSizeMode on the Bound OLE Frame. "Stretch" and "Zoom" will
fit the picture to the size of the frame, without and with retaining
proportions, respectively. The frame may have been sized inordinately large
when created, depending on the image, if any, specified in its Picture
property.

Larry Linson
Microsoft Access MVP

 

[Guest]

Thanks Larry.

That worked a treat, both in my form and report. That makes it now
incredibly easy to store and link to images - no need to mess around getting
the image size just right.

Cheers, JohnB

 

[Larry Linson]

Thanks Larry.
That worked a treat, both in my form and
report. That makes it now incredibly easy
to store and link to images - no need to
mess around getting the image size just right.

You're most welcome, but if you'd really like a treat, download the imaging
examples from http://accdevel.tripod.com and take a look at the two
approaches that do not use OLE Objects. They may be even better and more
efficient.

Larry Linson
Microsoft Access MVP