Solved

Linked images on form are pixelated?

Posted on 2012-03-13
7
658 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 

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

Independent Software Vendors: 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

Suggested Solutions

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

710 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