Listbox with Hyperlinks

[teel73]

I have a table with a field called "RequestNames". The field type is set to hyperlink. When I open my table, I am able to click on a value in that field and it takes me to the destination.

But here's my problem.

I am using that table as my rowsource for my listbox but the values aren't displayed as hyperlinks. How can I get my listbox to display the values as hyperlinks?

 

[boblarson]

As far as I know, listboxes can't display hyperlinks. So use a subform instead and format it to look like a listbox by using it in Continuous view and changing several of the properties.

 

[jdraw]

If you store the hyperlinks as text (depending on your context)
you can have them in a list box and an event such as this

Private Sub List0_Click()
Application.FollowHyperlink Me.List0.Value

End Sub