I have a situation where each record in the table being reported could
have 0-5 pictures associated with it. I want to print those pictures,
if they exist, with each record's report. I cannot figure out a good
way to do this. I have been attempting to place 5 Image controls in the
Detail area of the report, organized vertically, so one comes before
the next as you go down the page. Then, in the report's VBA module, I
was trying to check the appropriate fields in the record, if the field
contains a path to an image then, I attempt to set the image control's
size (each image is approx 7.5 x 10) and set it's visible property to
true. If there is no path, then I was trying to set the
ImageControl.Visible property to false, and go on.
If I try to set the image control's size during design time, then I run
out of space on the report. It seems to have a size limit (about 21
inches) that will not let me add 5 image controls that each have a
height of approx 10 inches.
This is apparently impossible to do. I cannot set the control's Height
and Width properties during runtime, which seems amazing to me, nor can
I access the control's SizeToFit method. There are quite a few other
challenges as well.
Does anyone have a suggestion as to how to accomplish this task?
Let me know if you need more detail about this. Thank you.
Duane Hookom - 27 Dec 2006 22:28 GMT
I would start by normalizing the table so that the 0-5 image file references
become 0-5 records in a related table. If you can't change your table
structure, you can use a union query to normalize.

Signature
Duane Hookom
Microsoft Access MVP
> I have a situation where each record in the table being reported could
> have 0-5 pictures associated with it. I want to print those pictures,
[quoted text clipped - 20 lines]
> Does anyone have a suggestion as to how to accomplish this task?
> Let me know if you need more detail about this. Thank you.
raja - 28 Dec 2006 18:20 GMT
Thank you for your reply.
Yes, the database I am working with is not even close to being
normalized. It is a temporary database created specifically for
reporting purposes (this is not my design, I started this job 2 weeks
ago) and, as soon as the reporting is done, the database is deleted (I
know that sounds crazy).
My problem really isn't accessing the image reference fields, its
figuring out how to display them. Since I can't dynamically size the
image controls, and the report size is limited in design mode, I am
limited to displaying only one of the 5 potential images. It seems like
it should a simple task but, I can't figure it out.
Thanks, again.
Roger
> I would start by normalizing the table so that the 0-5 image file references
> become 0-5 records in a related table. If you can't change your table
[quoted text clipped - 28 lines]
> > Does anyone have a suggestion as to how to accomplish this task?
> > Let me know if you need more detail about this. Thank you.