This poor image quality in MS Access report image control mysteriously shows up and had me scratching my head for awhile. If you are using the image control to show your images on a report, and though your image is good quality (and shows up fine outside of MS Access), is showing up with strange noise, purple effects and looks like this:
Then you need to change a setting to make the picture quality better.
FIX:
Go under the Office Button>>Access Options>>Current Database
Find where it says "Picture Property Storage Format" and change the setting to "Convert all picture data to bitmaps (compatible with Access 2003 and earlier).
Presto magico, your image is back to normal!
5 comments:
No good for me. The buttons are all "greyed out" and don't work.
It is work very well for me.
Really appreciate.
Thank you.
The solution also worked for me. However, I have two reports with images. The first report displayed images properly with the fix but the second report showed distorted images as described pre fix. I found a solution and set out here in case someone else is also getting mixed results.
My first and second reports contained the same type of image controls to display images (from links) (not embedded images). By using the Access 'Database Documenter' (Database Tools - Database Documenter) I compared the properties of each report and discovered that I had not set the Property Sheet 'Data' tab 'Control Source' for the problem report. In my case there was no entry for the control source which I guess led to the image display problem. Once I set the Control Source to be the same as the working report (in my case this was 'image' from the drop down list of control sources) it was fine. The images in both reports now display properly. I hope this helps someone.
Brilliant. Suffered this for years. Well done.
I also suffered for a few days before finding this solution...
For redistribution, do not forget to set the Current database option in VBA as follow :
Application.SetOption "Picture Property Storage Format", 1
Hope it can help !
Post a Comment