resize photo size automatically in ACCESS form & Report

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/9291-resize-photo-size-automatically-access-form.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9291
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
--
Rasoul Khoshravan Azar
Civil Engineer
Osaka, Japan

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

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

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9291

"Khoshravan" wrote in message
news:23E95B60-C65D-4F0A-95F4-5D17915F88C0@microsoft.com...
> Access 2002
> I am displaying some photos in Access by the method explained in:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9291
> 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
> --
> Rasoul Khoshravan Azar
> Civil Engineer
> Osaka, Japan

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


"Larry Linson" wrote:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9291

> 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
>
>
> "Khoshravan" wrote in message
> news:23E95B60-C65D-4F0A-95F4-5D17915F88C0@microsoft.com...
> > 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9291
> > 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
> > --
> > Rasoul Khoshravan Azar
> > Civil Engineer
> > Osaka, Japan
>
>
>

"Khoshravan" wrote

> Thanks for your info. While going around in the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9291
> ACCESS I was able to find it by myself.

You are welcome. Glad you solved the problem -- sometimes these things are
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9291
"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

Dear Larry
Address of issue:
2nd page in your article. ...At the Microsoft web site,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9291
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"
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9291
issue without omitting it.

--
Rasoul Khoshravan Azar
Civil Engineer
Osaka, Japan


"Larry Linson" wrote:

> "Khoshravan" wrote
>
> > 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
>
>
>

"Khoshravan" wrote

> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9291
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9291
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

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9291
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.
--
Rasoul Khoshravan Azar
Civil Engineer
Osaka, Japan


"Larry Linson" wrote:

> "Khoshravan" wrote
>
> > 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9291
> > 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
>
>
>