Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

resize photo size automatically in ACCESS form & Report

Discussion in 'Information Technology' started by Khoshravan, Jul 28, 2006.

  1. Khoshravan

    Khoshravan
    Expand Collapse
    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
    --
    Rasoul Khoshravan Azar
    Civil Engineer
    Osaka, Japan
     
  2. Loading...


  3. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    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" <khoshravan@discussions.microsoft.com> 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
    > 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
     
  4. Khoshravan

    Khoshravan
    Expand Collapse
    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


    "Larry Linson" wrote:

    > 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" <khoshravan@discussions.microsoft.com> 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
    > > 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

    >
    >
    >
     
  5. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    "Khoshravan" <khoshravan@discussions.microsoft.com> 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
     
  6. Khoshravan

    Khoshravan
    Expand Collapse
    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.

    --
    Rasoul Khoshravan Azar
    Civil Engineer
    Osaka, Japan


    "Larry Linson" wrote:

    > "Khoshravan" <khoshravan@discussions.microsoft.com> 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
    >
    >
    >
     
  7. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    "Khoshravan" <khoshravan@discussions.microsoft.com> 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
    > 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
     
  8. Khoshravan

    Khoshravan
    Expand Collapse
    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.
    --
    Rasoul Khoshravan Azar
    Civil Engineer
    Osaka, Japan


    "Larry Linson" wrote:

    > "Khoshravan" <khoshravan@discussions.microsoft.com> 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
    > > 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
    >
    >
    >
     

Share This Page