Results 1 to 12 of 12
  1. #1
    Bronze Lounger
    Join Date
    Feb 2001
    Location
    Escondido, California, USA
    Posts
    1,458
    Thanks
    0
    Thanked 1 Time in 1 Post

    Picture Size (Access 97 SR1 W98)

    I'm having a problem with displaying pictures in a form. No matter what I do (select Zoom, Clip, etc.) the picture only occupies about 1/9th of the area of the control box that it is in, and it includes the picture file name underneath. I've tried changing just about every property that would effect the size or presentation of the picture to no avail. <img src=/S/headthrob.gif border=0 alt=headthrob width=15 height=15> Any suggestions would be most welcome.

  2. #2
    New Lounger
    Join Date
    Aug 2001
    Posts
    18
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Picture Size (Access 97 SR1 W98)

    Chuck,
    Is it possible that the problem lies with the actual picture(s)? Have you cropped or clipped them to only include the picture and exclude any white space around them?

    As for the filename being displayed underneath, that could also be a product of the picture viewer you're exporting the pics from. Try playing around with the options when cutting/copying images out of it (assuming that you're embedding the pictures in Access rather than linking them)

  3. #3
    Bronze Lounger
    Join Date
    Feb 2001
    Location
    Escondido, California, USA
    Posts
    1,458
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Picture Size (Access 97 SR1 W98)

    Hi,

    I used MS Paint to generate the pictures. They don't include the picture file names embedded in the picture. I am linking to all pictures. It remains a puzzlement.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Picture Size (Access 97 SR1 W98)

    If you set the image control's Size Mode property to Stretch, it should adjust itself to fill the control. I don't know why you would see the file name at all. You are using an image control, right?
    Charlotte

  5. #5
    Bronze Lounger
    Join Date
    Feb 2001
    Location
    Escondido, California, USA
    Posts
    1,458
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Picture Size (Access 97 SR1 W98)

    Hi Charlotte,

    Thanks for your suggestions, but nothing changes my problem. I'm using a bound object frame for the picture. After investigating this for several days I think what is happening is that the Display Type Property is hung on Icon even though I have it set to Content. When I switch the display type to Icon there is no change in the display, and I'm pretty sure that's why I always get the file name underneath the image - it's treating it like an Icon. In addition, the image resolution is extremely low (i.e. about like what an icon would use). So I think I'm stuck on an Icon display type.

    There must be something funny with my Access97 setup, or perhaps I don't have a proper Add-in or ? I don't know where else to look for a cure.

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Picture Size (Access 97 SR1 W98)

    WHY are you using a bound object frame. The image control is what you need for displaying pictures reliably. I'm attaching a zip file that contains a simple Access97 database and some graphics files. Extract them all to the same folder and then open the Images97.mdb and open frmImages. You should see various images displayed in the form as you move between records. Let us know if it doesn't work on your machine because it works on mine.
    Attached Files Attached Files
    Charlotte

  7. #7
    Bronze Lounger
    Join Date
    Feb 2001
    Location
    Escondido, California, USA
    Posts
    1,458
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Picture Size (Access 97 SR1 W98)

    Thanks again for your efforts. Your db works just fine. The pictures show up exacly as they should.
    But I must be missing something big time about images.

    When I select the Image control on my toolbar and then click inside my form it immediately opens up a window titled "Insert Image." It is just like an Open File window where you select a file to be loaded. In this case I can insert an image from a file somewhere on my computer (but NOT from a record in my database), and it simply permanently inserts that picture into the form just like a label.
    Is there another different "Image" tool that I don't have configured on my toolbar?

    Also, when I look at your image properties. the picture format says (none), and there is no Control Source property to specify where in the table to get the picture link. How does it know what field in the table contains the link to the picture when there is no Control Source specified in the Image control? I think I must really be missing something important here regarding images. They certainly don't work like any other control.

    Perhaps I should explain my application a bit more. My database has a table that contains a list of products and one of the fields is named "Picture" and is the type OLE Object. This is where I store the picture (using "Insert Object", "Create from file" with the Link box checked). Supposedly this creates a field with a link to the picture. When I do this, the field displays the text "Package" (whatever that means.) The other option in the Insert Picture dialog box is "Create New." If I select bitmap as the object type and then click on OK, the Paint program opens up permitting me to create a bitmap image. But here is the curious part, the File menu in Paint doesn't have the New, Open, Save or SaveAs options. So I can't load any existing bitmap image. All I can do is create a new one.

    If I exit Access and open Paint in the normal fashion, say, from the Star|Programs|Accessories menu then it has those typical options.

    I remain quite baffled by the entire thing.

  8. #8
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Picture Size (Access 97 SR1 W98)

    When you first insert an image control, Access makes you point at an image. If you link it to some image, you can save the control. After the fact, you can use code to set the picture property of the image control to the path of whatever image you want to display or even to an empty string. If you look in the code behind the form, you'll see the simple code required to pass the correct image to the image control. I have never had much luck with other methods of displaying images. Using the image control and a path string works the best for me and appears to be the fastest method as well.

    Package is what you see when you insert an OLE object link into a table. It probably means something to Microsoft, but it has always left me scratching my head. The behavior you see with Paint is not unlike what happens with Word or Excel if you do a create from file using those as the object. You aren't really running a full version of Paint (or Word or Excel), so the functionality tends to be whatever the current app engine (in this case Access) will allow. I'm sure there's a methodology for making it all work, but I've never had the patience to track it down and master it. Life is too short for some kinds of frustration. <img src=/S/yep.gif border=0 alt=yep width=15 height=15>
    Charlotte

  9. #9
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Picture Size (Access 97 SR1 W98)

    To add to what Charlotte wrote, in addition to trying to figure out how to use them, there is another very large problem with OLE Objects in Access tables. They make your database grow like crazy. We had a client who tried to put a jpeg photo into each of 1200 records. It seemed very logical, as the individual photos were typically 25 to 35 KB, but for each picture added, the database grew over 1MB. Bottom line - they would have exceeded the maximum database size for Access. You are MUCH better off to store the images outside the database and use a file location in your table to set the source for your image control.
    Wendell

  10. #10
    Star Lounger
    Join Date
    May 2002
    Location
    Patagonia Region Chile
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Picture Size (Access 97 SR1 W98)

    Charlotte

    I got your attachment on linking images and it is exaclty what I want to do. Thank you.
    It applies to a form. How Can I do it on a report?

    Jason

  11. #11
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Picture Size (Access 97 SR1 W98)

    Hi Jason,

    It works almost exactly the same on a report, except that you must use the On Format event of the Detail section of the report instead of the On Current event of the form.

    I have attached a zipped Access 97 database that demonstrates this. There are no images included; use the form to insert some images, then preview the report.
    Attached Files Attached Files

  12. #12
    Star Lounger
    Join Date
    May 2002
    Location
    Patagonia Region Chile
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Picture Size (Access 97 SR1 W98)

    Hans

    Thanks. I am on my way.

    Truly.
    Jason

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •