hyperlink doesn't work in a report

  • Thread starter Thread starter jbackstr
  • Start date Start date
J

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
 
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
 
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
 
Back
Top