Large size Images are not displayed on report

[Cris]

I have a report which display one or more pictures. I load the pictures on formating event of the report. The path is stored on a text field in the database and the pictures are saved on a folder.

My pictures are jpeg's. I asign the file name to the picture property to the image control.

imgPhoto.Picture = fileName

When I test with small size pictures I have not problem. But I really need to be able of add large size pictures to my project, I tested pictures of 3 Mb.

I tried this code from http://www.lebans.com/printfailures.htm where it is proposed to convert the jpeg's to a bitmap file. That works but the pictures lost a lot of quality, they are not useful like that.

I'll thank you for your help.

 

[boblarson]

I found that Access Reports do not like more than about 5 or 6 photos in a high resolution. We had to limit our use to 640 x 480 resolution to make them all show up on the Access Report (we typically had anywhere from 12 to 25 photos we needed on a report).

 

[Cris]

Thanks for your answer

Well, in that case, that means i am going to need to resize the pictures. Somebody knows how to change size of jpegs with vba code?

 

[boblarson]

Thanks for your answer

Well, in that case, that means i am going to need to resize the pictures. Somebody knows how to change size of jpegs with vba code?

I looked into that and (pardon the pun) it wasn't a pretty picture.

I found that we could open the pics in Microsoft Picture Manager and then do a resample quickly and then save and open the next. So we made it each employee's responsibility to resize their own pics for their reports.

But I know that might not be possible for you. So good luck in doing it via VBA. If you find out, repost the solution as it would be helpful (if the solution is not posted here to begin with).