Image resolution from Access 2003 to Access 2010

Posted on 2011-10-12
Last Modified: 2013-11-28
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?
Question by:kerryw60
    LVL 6

    Author Comment

    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...
    LVL 38

    Expert Comment

    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.  
    LVL 1

    Expert Comment

    Go to File > Options > Current Database and select "Preserve source image format".
    LVL 74

    Accepted Solution

    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?
    LVL 74

    Expert Comment

    by:Jeffrey Coachman
    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)


    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    IF SQL Statement Access SQL 6 38
    Running Sum Help 31 22
    Order by 8 20
    Access left join query 5 17
    Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    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.

    729 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

    18 Experts available now in Live!

    Get 1:1 Help Now