Report will only create 5 or 6 pages

[Normever]

I have a report that has an image in the detail section that is a jpg. The report works fine, pulling in the appropriate image for the first 5 or 6 records then it stops pulling in the jpg data. If I do a small report with only a few records all the images work. Once it gets up to 5 or 6 records the images are either blank or the placeholder picture. I want to create a report with 100's of images.

Is there a relatively small limit on the amount of data that can go into a report?

Thank you,
Norm

 

[vbaInet]

Welcome to AWF

Have a look at the following link re the disadvantages of your current way of working with images:

http://office.microsoft.com/en-us/access-help/store-images-in-a-database-HP005280225.aspx

Then see how best to do what you want:

http://support.microsoft.com/default.aspx?scid=kb;en-us;285820

 

[SteveSchapel]

Norm,

You didn't mention what version of Access you are using. If Access 2007 or 2010, you will have a Control Source property for the Image control on your report, and you will find that using that will be very efficient. If using old versions of Access, this is not possible, and the advice given by vbaInet may be applicable.

 

[Normever]

I am in Access 2010. I continue to have problems. I have a field in my table that is the path to the images. I open the report and reference the table as my data source. Then I set up a Report header and a page header. Then in the detail section I have a image control. In the detail properties in "on Format" I have a small code that sets the image control picture property to a control on the report that is the path. It works off and on. Sometimes the page is blank, sometimes it prints the image upside down, and sometimes it looks correct. And then usually after about 6 pages all the images are blank, but the page header is different for each record, but the image does not show. All the images in the folder are right side up and correct. I have the image control set to "Linked". I'm still lost.

 

[SteveSchapel]

Norm,

I suggest you completely remove this code you have on the Format event of the report's Detail section. And remove the other control (textbox?) on the report that points to the image. I suggest you simply set the Control Source property of the Image control to the field that contains the path/file for the images. Let us know whether that helps.