resize photo size automatically in ACCESS form & Report

[Guest]

Access 2002
I am displaying some photos in Access by the method explained in:
ACC: How to Display Images in a Form or in a Report Without Storing the
Images in a Table, Article ID : 148463, Last Review : August 12, 2005,
Revision : 3.1
Photos are jpg format and are sent to me by email.
Photos seams to have different sizes so when they are displayed in Report
preview they are cut in top or buttom.
Is there any command to resize the photo size to fit the allocated box
precisely & automatically? TIA

 

[Larry Linson]

The Image control has a property, SizeMode, which can be set to Clip,
Stretch, or Zoom. Zoom automatically resizes the image, retaining the aspect
ratio of height to width.

Larry Linson
Microsoft Access MVP

 

[Guest]

Hi Larry
Thanks for your info. While going around in the ACCESS I was able to find it
by myself.
I was reading your article "Images in ACCESS Database" Three approaches
edited in 25 May 2001. If you have come up with a solution for "class", as
you have omitted them in that article, let me know.
--
Rasoul Khoshravan Azar
Civil Engineer
Osaka, Japan

The Image control has a property, SizeMode, which can be set to Clip,
Stretch, or Zoom. Zoom automatically resizes the image, retaining the aspect
ratio of height to width.

Larry Linson
Microsoft Access MVP

 

[Larry Linson]

Thanks for your info. While going around in the
ACCESS I was able to find it by myself.

You are welcome. Glad you solved the problem -- sometimes these things are
"hidden away" in places that are not obvious to everyone.

I was reading your article "Images in
ACCESS Database" Three approaches
edited in 25 May 2001. If you have come
up with a solution for "class", as
you have omitted them in that article, let me know.

I am not sure what you mean by 'come up with a solution for "class"'. Can
you clarify? There are some other approaches to displaying images, not
covered in that article, but I don't understand what "class" is involved.

Two additional approaches that come to mind are using a hyperlink to display
a picture, or using an unbound OLE frame to display a picture. I haven't
thought those were of sufficient difficulty, or interest, to revise the
article.

Larry Linson
Microsoft Access MVP

 

[Guest]

Dear Larry
Address of issue:
2nd page in your article. ...At the Microsoft web site,
http://support.microsoft.com... in third line of that paragraph you say: "I
could not determine the class of the JPG image file that I was loading I
omitte that ....

Well I omitted also and works fine but I want to know what is this class
mentioned in knowledgebase and how can I utilize it.

Regarding using the word "come up" sorry maybe I was using a wrong
expression. I wanted to say: If you have find any new method to slove "class"
issue without omitting it.

 

[Larry Linson]

2nd page in your article. ...At the Microsoft web site,
http://support.microsoft.com... in third line of that
paragraph you say: "I could not determine the class
of the JPG image file that I was loading I
omitte that ....

Ah, _that_ class.

Well I omitted also and works fine but I want to
know what is this class mentioned in knowledgebase
and how can I utilize it.

Because that class did not appear to be necessary for anything I wanted to
do, I did not spend time and energy searching for more information. And, in
fact, soon forgot (as you saw), that it even existed. Thus, I'm sorry I
don't have any additional information to offer.

Larry Linson
Microsoft Access MVP

 

[Guest]

Dear Larry
OK you remebered which class I am talking about but it is not an issue for
you (at least at present). The expression "class" is totally new for me and
this is first time I hear about it. Could you please guide me to a site or
other place to get the basic info about what is "class" in ACCESS?
Thanks for your replies.