Solved Display data in list box as hyperlink

[SQL_Hell]

Hello,

I am creating a simple access form for pulling file data out of an old SQL server, I would like to display the data in a listbox as hyperlinks, so people can click on the link and retrieve a file.
I have tried using the hyperlink data type but not all my data contains valid hyperlinks, so the conversion fails.

Is there any other way I can do this?

 

[arnelgp]

you can just add a Code to the dblClick Event of the list to retrieve the file:

Private Sub List0_DblClick(Cancel As Integer)
Application.FollowHyperlink Me.List0
End Sub

 

[SQL_Hell]

Thanks a lot, yeah I will probably go this route. I would have preferred it displayed as blue underlined hyperlink in the conventional sense, but I suppose it doesn't matter too much.

 

[Minty]

You can make the text blue and underline it to give the effect.

 

[SQL_Hell]

That's a good idea, I will give it a go.

 

[arnelgp]

you can also try using a Subform (datasheet).
and format the Textbox as Hyperlink.