Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Linked images on form are pixelated?

Posted on 2012-03-13
7
Medium Priority
?
704 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 85
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
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 

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 1500 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

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

916 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