Thousands of unique images on Access reports
Let's say you have a folder full of 4000 dpi x 3000 dpi images and a table with records containing the full path to said same.
Now you build a nice little report with a 4" x 3" image control on it in the Detail section, with a couple of columns.
Next bind the report to the table full of paths.
Throw on the controls from the field(s) that have the path.
Then build a Detail_Format event that will set the Image control's .Picture property to the path.
Try to preview your report.
How long before the report no longer displays the images?
20, 30 images, maybe 40 until blank spots start appearing or the image doesn't refresh? (double, triples)
How long before Access hangs trying to display the next page?
How long before Access bombs and dies? (Usually with an 'out of memory' error if not an outright GPF) if you try to print the report unless it succeeds at printing pages full of blank squares where the images should be.
Well if it doesn't display correctly and doesn't print it, it doesn't matter overly but the answer is usually less than 70 depending on the power of the hardware involved and whether you've taken more than one run at getting it to work. But in short, it doesn't work. You won't get WYSIWYG.
Now try 4 columns of 2 x 1.5" controls
Really? Still? In 2018?
With some legerdemain and the WIA library I can get to about 650 images. How come that wasn't fixed long ago?
And how come the images in the preview (jpg) now look like crap but print ok? They looked (and still do look good) in Access 2003. What's with that?
How's about you FIX all the things you broke after Access 2003 -- like context-sensitive F1 VBA offline help, and respect for image transparency?
Philipp Stiefel commented
We ran into the very same problem with images no longer displaying on the report. For us the problem started already after less than 10 images were displayed! - We were able to build a workaround for the problem by creating small thumbnails of the images at runtime before displaying them in the report.