columnar report displaying jgp images

[toddr]

I have created a report in Access 2007 which will print a contact sheet of
jpg's and the path to the jpg. I created the report and it works fine but in
preview and print mode it does not display/print all the jpgs. there are 6
columns and 3 rows per page. it only displays/prints the first 8 images per
page (sometimes less).

If i print in one column it correctly prints/displays all jpg images. I have
also tried to save to a pdf and that does not work either.

How can i get the report to correctly print and dispay all the jpg's?

Can anyone help?

 

[Allen Browne]

How are you storing these images?
Are the embedded in the database (OLE field)?
Or are you just storing the path (Text of Hyperlink field)?

If just the path, the Image control in Access 2007 has a Control Source
property. This is different to previous versions, and makes the task so
easy.

Say you have the path in a text field named MyImagePath. In report design
view, you just place an Image control on the report, and set its
ControlSource to:
=[MyImagePath]

 

[toddr]

yes, i am storing the path and in the image control i have the path for the
control source.

the report works it just does not display all the images properly. it will
display/print 8 on the first page then 5 on the second, etc.

there are 6 columns across the page and 3 down.

if i make the report 1 column or look at it in "report view" it dispalys all
the images properly.

I have tried changing all the properties on the report and image control and
that does not seem to fix it.

Any other suggestions?

How are you storing these images?
Are the embedded in the database (OLE field)?
Or are you just storing the path (Text of Hyperlink field)?

If just the path, the Image control in Access 2007 has a Control Source
property. This is different to previous versions, and makes the task so
easy.

Say you have the path in a text field named MyImagePath. In report design
view, you just place an Image control on the report, and set its
ControlSource to:
=[MyImagePath]

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have created a report in Access 2007 which will print a contact sheet of
jpg's and the path to the jpg. I created the report and it works fine but
in
preview and print mode it does not display/print all the jpgs. there are 6
columns and 3 rows per page. it only displays/prints the first 8 images
per
page (sometimes less).

If i print in one column it correctly prints/displays all jpg images. I
have
also tried to save to a pdf and that does not work either.

How can i get the report to correctly print and dispay all the jpg's?

Can anyone help?

 

[Allen Browne]

Do you have any code in the report's module? If so, post it.

If not, it sounds like a bug, particularly as:
a) the ControlSource of images is new in A2007, and
b) a single-column report works correctly.

 

[toddr]

no, there isn't any code in the report. there are just 2 controls; the image
control and a text box which prints the full path to the image.

it is very strange indeed. i could post a screen shot but i do not see how
to do that.