I have built a report which uses a table that accesses photos via a text field in a table, which indicates the loction of the .jpg file on my hard drive. Got it working well. There are 10 records per page, I am using it for an inventory identication sticker which includes a small photo of the part as well as part no. etc. Printing on Avery stickers. When I open the report, page 1 displays quickly with little fuss. But as I advance to further pages, it takes longer and longer to display. Eventually around page 5 or 6 I start hearing lots of disk accessing, like swapping memory or whatever. And printing a page at that point (page 5 or 6 for example) takes forever, and some of the photos are missing on the printout. It seems like Access is loading every photo into memory prior to the page I am trying to look at and/or print, and eventually there's not enough memory to perform the printing. Is this possible? If so is there any workaround that would release all this unused data from memory?

What is the size of your pictures? Reducing the dimensions does not reduce the size.
I have worked with reports that show 15+ pics (around 20K each) per page without problems.

Your images should be no more than 600 pixels and up 100Kb average 20-50Kb and I use a SubReport for the images.

Simon

Thanks folks. That was the problem, file size. It's working now with smaller photos. HM.