Solved

Linked images on form are pixelated?

Posted on 2012-03-13
7
668 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 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
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 

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

Ready to get started with anonymous questions?

It's easy! Check out this step-by-step guide for asking an anonymous question on Experts Exchange.

Question has a verified solution.

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

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
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 …
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…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

636 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