kerryw60
asked on
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?
All of this works expect the images were all crystal clear in Access 2003 and they are all fuzzy in Access 2010.
Any suggestions?
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.
http://office.microsoft.com/en-us/access-help/modify-edit-or-change-a-report-HA010014117.aspx
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.
http://office.microsoft.com/en-us/access-help/modify-edit-or-change-a-report-HA010014117.aspx
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".
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
See this Q:
https://www.experts-exchange.com/questions/26299537/Image-quality-on-report-preview-stinks.html
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)
JeffCoachman
https://www.experts-exchange.com/questions/26299537/Image-quality-on-report-preview-stinks.html
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)
JeffCoachman
ASKER