hyperlink doesn't work in a report

[jbackstr]

I have a hyperlink to an image in my database. In the report, the page where
the hyperlinked image should be is blank. I read on microsoft's web site
that hyperlinks don't work in reports. Any help would be appriciated. thanks

 

[Ken Sheridan]

In the report use an Image control to display the image. Assuming the
hyperlink column contains the paths to the image files located in a folder or
folders on your system you can then assign the path to the image control's
Picture property in the report's detail section's print event procedure.
You'll need to include a hidden text box control, txtImagelink say, in the
detail section, bound to the hyperlink column. The code for the detail
section's print event procedure would then go like this:

If Not IsNull(Me.txtImageLink) Then
Me.YourImageControl.Picture = Me.txtImageLink.Text
Me.YourImageControl.Visible = True
Else
Me.YourImageControl.Visible = False
End If

Ken Sheridan
Stafford, England

 

[jbackstr]

Ken, Thanks for your input. I don't fully understand the solution since I'm
a beginner with access. I need to do some homework to try your solution.
Thanks