• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1934
  • Last Modified:

Image resolution from Access 2003 to Access 2010

Created a database several years ago in Access 2003 and has worked great for years. Recently, the client asked me to come in and upgrade them to Access 2010.  With no real changes, the database works.  The ONLY hangups are the reports that display images.  The images are actually stored in a file folder on the server, are referenced by name to display in the reports.

All of this works expect the images were all crystal clear in Access 2003 and they are all fuzzy in Access 2010.

Any suggestions?
1 Solution
kerryw60Author Commented:
By the way, this is in Print Preview - if I am in Design View, the images are still crisp.  The thing is, I need the reports to open to the user as Print Preview - AND YES, they are even printing fuzzy where they were not before...
I believe the distortion you are experiencing is because the default size mode for an image was changed to "Clip" for MS Access 2007 and later versions.  Try changing the Size Mode to either Zoom or Stretch, in accordance with your intentions for the "looks" of the image.


Excerpt from link above:
Note that the default value for the Size Mode property of an image is Clip, meaning that the image will stay the same size regardless of how large or small you make the image control. If you want the image to get larger or smaller as you resize the control, do the following:

Resize the logo or image inside the control
Select the image.
If the property sheet is not already displayed, press F4 to display it.
On the Format tab of the property sheet, set the Size Mode property to the option you want:
Setting Description
Clip The image stays the same size, regardless of how large or small you make the image control. If you make the image control smaller than the image, the image is clipped.
Stretch The image is stretched both vertically and horizontally to match the size of the image control. The original aspect ratio of the image is not preserved, so this setting can result in a distorted image unless you precisely set the height and width of the image control.
Zoom As the image control is resized, the image adjusts to be as large as possible without affecting the original aspect ratio of the image.  
Go to File > Options > Current Database and select "Preserve source image format".
Jeffrey CoachmanMIS LiasonCommented:
What types of images are these?
(.jpg and .bmp images work best)

What resolution are the images?

How, "specifically" are you displaying the images? (What code, what type of control, ...etc)

Do you have a fairly "beefy" video card, and up to date drivers?

Does this same "fuzziness" appear in forms as well?

Can you post a screenshot of the clear and fuzzy report images?
Jeffrey CoachmanMIS LiasonCommented:
See this Q:

Here the issue was a combination of using only jpg images and making sure that the images themselves were not huge (in terms of the images dimensions)

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now