Table/Report - Hyperlink (1 Viewer)

[Cabot]

I have created a column in my table and set the data type to a hyperlink that links to a folder that holds photos (jpg). I am able to click on this link and get to the picture that resides in that folder. When I create a report I am getting the link address and would rather see the picture... is there a way this can be accomplished?

 

[dynamictiger]

Add an unbound image control to your report. In the onactivate event add code like:

Me.imgMyPicture.Picture=Me.PicturePath

Caution onActivate fires more than once, it is a good idea to test to see if the picture is already populated so that you do not run the process more than once.

It is also wise to check for nothing in the picture path.

 

[Cabot]

I'm not sure I understand the reply... where's the onactivate event?... how do I add an unbound image control?