How to Link to Photos to each Record and Display in Report (Access 2010)

[giblets]

How can I link multiple images from a folder on my drive to each record without making the database file huge?
Each record is a plant species. I want to link to photos of flower, seed, etc. See attached database example.

I would then like those images to appear on a report for each species. How would I go about doing this, if it is indeed possible? Thanks!

[June7]

Store the image path\name in a text field in table. Use an Image control with ControlSource set to the field.

[giblets]

Store the image path\name in a text field in table. Use an Image control with ControlSource set to the field.

I'm not quite sure how to "use an Image control." I inserted an image (just chose a random image from my desktop), then changed the Control Source field to the field with the file paths/names of images. However, no images appeared when I switched over to Report View. How do I "use an Image Control"?

Thanks!

[June7]

What do you mean by 'inserted an image'? If you want to reference external image files, just save text string for the path\filename.

You can either put the full path string in the text field:
C:\Images\image1.jpg

Then the ControlSource would be:
=[fieldname]

Or enter just the filename in the field and concatenate the path with the field name:
="C:\Images\" & [fieldname]

Works for me.

If you want to provide the database, I will test the setup.

[giblets]

I get the point about entering the file name for each record in the table, but when I go to the report, I'm not sure what I'm supposed to click to place an image next to each detailed record. See attached example database in my first post. The column "leaf" in the Plant Inventory would be an example of where I would place the file name.

Thanks!

[June7]

Oh, did not see the zip link.

I did these steps with your report.

1. report in design view

2. drag Image control from ribbon Design tab into Detail section (Cancel on the wizard to add image)

3. set ControlSource, I used photobloom field

4. enter data in field, I used a jpg from my folder

It works.

[giblets]

Indeed it does! I think the problem I had was that I chose a random image instead of canceling the wizard to add an image. Thanks!