Solved

Linked images on form are pixelated?

Posted on 2012-03-13
7
632 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

920 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now