Hyperlink category in a listbox

[Pontus]

Hello!



I have a listbox which displays a couple of categories.

I import the data to the listbox via the wizard.
For example:
Manufacturer: short Text
Type: short Text
Link: Hyperlink

Everything shows up in the listbox, however the Link category items with the hyperlinks are no longer clickable.
I want them to be clickable or at least copyable. When I'm copying them right now I get the string:

"#http://www.RandomLink.com/#"

Thanks in advance!
Best regards Pontus

[ItsMe]

My preference is to not use the Hyperlink type at the table level. Instead, I use the data type Text at the table level and store the path as literal text. Then, I can use the Hyperlink property in controls or simply include the literal string in code to open stuff.

[Pontus]

My preference is to not use the Hyperlink type at the table level. Instead, I use the data type Text at the table level and store the path as literal text. Then, I can use the Hyperlink property in controls or simply include the literal string in code to open stuff.

Thanks for the quick answer, but how do I find this property for a list box? If I select the listbox I can't seem to find this property. I have changed the data type to Short Text instead of Hyperlink in the table.

[Pontus]

I solved it by changing the data type to Short Text and using this code:

Application.FollowHyperlink Me.List1.Column(0)

[ItsMe]

Sorry I did not get back to you. Glad you were able to work through it and thanks for posting your solution.