I have a report that will require multiple images but that number will vary depending on how many records are included in the report. Each record will have a total of 4 images so for example lets say company A has 40 records that would mean i need a report that has 80 images. I want to print out that report or export it to pdf and send it to them but then company B has only 1 record so that report would only need to show 4 images.
I know how to insert a image control and link to file path for that image and I was thinking to make this report i would need to make a report with the maximum number of images i can think of (lets say 80 for this example) then add vba to the On Load funtion that hides the null image controls that arnt needed but how do i make it so the section of the report with the image controls shrinks so i dont have a huge blank space in my report filled with empty image controls? I have set the section to can shrink but that doesnt work. Is there any way to do this?
thanks
I know how to insert a image control and link to file path for that image and I was thinking to make this report i would need to make a report with the maximum number of images i can think of (lets say 80 for this example) then add vba to the On Load funtion that hides the null image controls that arnt needed but how do i make it so the section of the report with the image controls shrinks so i dont have a huge blank space in my report filled with empty image controls? I have set the section to can shrink but that doesnt work. Is there any way to do this?
thanks