Opening a picture from Hyperlink

[jennilein]

I have a column in my table which contains a hyperlink to a product picutre. I would like for the picture to open in a report based on that hyperlink.

How do I do this? I've done it before, but I can't remember how and don't have that database anymore to refer to.

Thanks in advance for the help!

 

[NSNewey]

You need an image frame in your report then use this code
in the format event of the report section the image is in.

In this code, [Image] is the field name and

is the image control name

If Not IsNull(Me.Image) Then
Me.imgFrame.Picture = Me.Image.Hyperlink.Address
End If

This assumes that the field in the table is defined as a hyperlink.