Image Prints Bad Quality

[tekyge]

I have an access report linked to an image on the server and it displays on the report great but when I print the report letter the linked image qulity is very poor. Any help with this? Thanks guys

 

[missinglinq]

My personal experience has been that poor quality of a printed image is related to the printer, rather than with the image itself. Printers that do an exceptional job of rendering text often don't handle images well.

The Missinglinq

There's ALWAYS more than one way to skin a cat!

 

[tekyge]

In any other circumstance I would agree, however, the image prints fine if it is embedded in the report.

 

[MajP]

I have no idea if this is related, but this is the strangest thing I ever seen if VBA. I posted this a while back, and got no real replies as to why.

Original Post:

I have a database with a lot of images of different pieces of equipment. I save the images in a seperate folder, and load them in to image controls when needed. All images are saved with their System ID (example System1.BMP, or System1.JPG) I did some modifications to my code last night and all of a sudden the quality of the images went substantially down. I was baffled and tried for hours to fix it, and could only find one difference in the old and new code. I look in the folder to see if a bitmap or jpg exists with the System ID. If it exists, I set the image path and file name and then use this to load the picture in the image control. Example:

strImagePath = "C:\MyPicture\" & systemID & ".BMP"

The change in code was that I used lower case ".bmp". Example:

strImagePath = "C:\MyPicture\" & systemID & ".bmp"

I did not believe that this could make a difference, so I tested it many times, and that was the sole cause. Same thing happened with ".JPG" and ".jpg". Anyone ever seen this or can explain what is going on?

 

[tekyge]

Thanks for all your help. I did try that MajP but didn't get the same results the poster did. The linked image looks the same in the report as the embedded one, but does not look the same when you print it. I am at a lose