Help request for creating Reports with pictures

[Faoineag]

Good morning everyone, I need some help to be able to create reports containing images. I have a form containing a subform; on the form there are two combo boxes that filter the data from the query on which the subform is based. Also on the form I have a button that creates the report and so far everything works: the records are arranged horizontally as if it were an Excel file. Now I would like to try to insert the corresponding picture for each record. (I will preface this by saying that each record corresponds to a product that has its own product sheet where I have entered the description and the photo). So I took this report that I have already created, inserted an image control and then inserted the query field “image path”. On the “body” of the report in the ‘Event’ tab, “On formatting” I inserted this routine: Me.imgFoto.Picture = CurrentProject.Path & “\img\” & Me.txtPathImage.

Unfortunately, however, in the report the pictures do not appear. I hope I have explained myself well, because I cannot attach the db as it contains sensitive client data. I thank in advance those who will try to help me.

 

[theDBguy]

Rather than use code, you can simply add a calculated column in your query for the image paths.

 

[DHookom]

Also, I have had issues in the past with larger image files not rendering. Do you know the size of the files and have you tried with smaller files?

I would also add a line in your code to help troubleshoot:

Debug.Print CurrentProject.Path & “\img\” & Me.txtPathImage

 

[Mark_]

To save yourself a LOT of pain, please make sure that you use png files for your images. Other formats will occasionally not render.