Solved

Linked images on form are pixelated?

Posted on 2012-03-13
7
651 Views
Last Modified: 2012-03-29
Hi,

I'm using dynamically linked images on an Access 2007 form and the images appear pixelated even though I'm using the same images on a dynamic web page and they're displayed correctly there. I've also not 'oversized' them in Access.

Anyone got an idea how to fix that?

Thank you
0
Comment
Question by:Xeronimo
  • 3
  • 3
7 Comments
 
LVL 84
ID: 37713860
What type of images (jpeg, png, etc). How are you displaying them?
0
 

Author Comment

by:Xeronimo
ID: 37713890
The images are JPG.

I display them in an empty image object which I update using VBA in the OnPaint() event of the 'Detail' part of the form: Me.MyPhoto.Picture = "\\server\photos\" & Me.nomPhoto
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37715593
Please note that "Pixelated" is an over used and vague term.
I have heard "pixelated" used to refer to Blurry, or mis-colored images.

"Pixelated" is technically when the zoom factor is so high (or the resolution is so low) that all you see is "Pixels" and no real image is discernible
Some images are of such a high resolution and color depth that Access has trouble displaying the color properly (Size mode, video card, also play a part in this).  However this is not "Pixelated"
So can you post a screenshot of one of your Pixelated images to be sure...
See the attached images for reference

This issue has come up before.

It had to do with the resolution of the images being to high, and being jpgs.

Although jpgs are smaller in size, this size reduction is due to "compression"
Sometimes Access cannot display 'High resolution/compressed" files correctly.
Today's cameras digital cameras can crank out 10 mb jpg with millions of colors with no problem.
Most Image controls in Access were not designed to properly display these super large, high resolution, compressed images.

Try lowering the resolution of the camera manually, or converting the images to a lower resolution.
This may take some experimentation though...
PixelatedPoor Color resolution
JeffCoachman
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Xeronimo
ID: 37718739
Yes, the images ARE pixelated.
Their exact dimensions are 100x130pixels. And it doesn't matter if the 300DPI or 75DPI, they're always pixelated. The faces on them are still recognizable but they 'blocky' (unlike when displayed on a web page).
Any other ideas ... ?
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 500 total points
ID: 37719765
<I display them in an empty image object which I update using VBA in the OnPaint() event of the 'Detail' part of the form: Me.MyPhoto.Picture = "\\server\photos\" & Me.nomPhoto>

"empty image object"
Please be more detailed.
What is the name of the specific image object you are using...(There are at least 3 different controls Access can use to display images)

Why are you using the On Paint event of the detail section?
Unless you have a very specific reason for using this event, it may occur more than once, possibly slowing down performance, ...and giving no real benefit...
The Current event is typically used most of the time, with no ill effects.

Here is my simple sample.
Give it a try, and tell me what results you get with your images.

JeffCoachman
Access-BasicLinkFormReportImages.mdb
0
 

Author Comment

by:Xeronimo
ID: 37719796
Hi Jeff,

Actually I've already moved it to the Current Event!
And now I've just, in order to test it, changed the image.pictury type property and now they get displayed correctly, whatever the option I select there!?
Well, at least it works now :)

Thanks anyway!
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 37720481
<Thanks anyway!>
?

Didn't I suggest the On Current event...?
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question