Need help with displaying ComboBox contents (hyperlink involved)

[rgarber]

In a form I have a ComboBox field which queries a vendor table with just three fields in it: Vendor_ID (autonumber); Vendor Name (text); Vendor Link (html link)

The form's table only includes the Vendor_ID for looking up the Vendor Link and it's set to Number.

The dropdown box works fine listing only the Vendor Link(s). However, when the link is chosen from the drop down box and its shown in the combobox field, the link doesn't work. It does show the link but with a hashtag in front of it.

So, my question is what am I doing wrong? I'm pretty new to the current version of Access but I did use it a lot back in the mid90's. Might as well treat me as a newbie and I am a first time poster. Any help be appreciated! Thanks! - Rich

 

[arnelgp]

combobox only use Plain text to display and you are not doing anything wrong.

 

[rgarber]

Thanks!

Okay, maybe Plan B is a better idea. Like choose the vendor via a Combo link to display the vendor name and then create a field to copy the link to? A field that can display a hyper link? Maybe? Or is there a better way than Plan B?

 

[arnelgp]

see form Form1 on the demo.

 

[CJ_London]

You can use the followhyperlink in vba

Application.FollowHyperlink method (Access)

Office VBA reference topic

learn.microsoft.com

 

[arnelgp]

followhyperlink in vba

if Vendor Link field is Hyperlink field, then you need to get the second element of the array from this field:

example:

followhyperlink split(dlookup("[vendor link]","table1"),"#")(1)

 

[rgarber]

Thanks for the suggestions however it occurred to me more as I looked into this the field would have been redundant anyway. It seemed a good idea at the time but I already have a field that links to the purchase page what would they need to go to the vendor home page for? Basically this app is for me where I'm cataloging a ton of addons I either purchased or acquired free. So, for now, I'm withdrawing the question and I'm just going with the field showing the vendor and that is easy enough to do. But I have other questions I'll ask soon if you'all don't mind. Thanks again!

 

[theDBguy]

Thanks for the suggestions however it occurred to me more as I looked into this the field would have been redundant anyway. It seemed a good idea at the time but I already have a field that links to the purchase page what would they need to go to the vendor home page for? Basically this app is for me where I'm cataloging a ton of addons I either purchased or acquired free. So, for now, I'm withdrawing the question and I'm just going with the field showing the vendor and that is easy enough to do. But I have other questions I'll ask soon if you'all don't mind. Thanks again!

Hi. Welcome to AWF!

Ask away, that's what we're here for. Merry Christmas!