[RESOLVED] Command Button hyperlink property from Record

I am trying to assign a hyperlink field in my table to a command button on a form. I realize I could easily use a text box and show the field's value, but want the asthetics of a command button instead.

The form's record source has the field included in the field list. However, I can't figure out how to assign the command button's hyperlink address property to the corresponding record's hyperlink value.

Any thoughts?

What do you mean by "hyperlink field in my table"? Is it a grid in vb6 or an access db table or an Exccel link, etc.

Sorry for the confusion. I have a table in Access with the hyperlink address as a field. The form is based on that table. I just want to assign that hyperlink field to the hyperlink address property of a command button.

Is your form an Access form too then?

Quote:

---

Originally Posted by jtnelso

Sorry for the confusion. I have a table in Access with the hyperlink address as a field. The form is based on that table. I just want to assign that hyperlink field to the hyperlink address property of a command button.

---

There is no hyperlink property to a VB command button.

Yes, the table, queries, and forms are all in Access.

Hack, in Access, a command button has a "hyperlink address" property. That is what I am trying to populate using the table the form is bound to.

Quote:

---

Originally Posted by jtnelso

Yes, the table, queries, and forms are all in Access.

Hack, in Access, a command button has a "hyperlink address" property. That is what I am trying to populate using the table the form is bound to.

---

Ahhh....then this really should be in the VBA/Office Development section. Otherwise, you are probably going to get more posts like mine wondering what the heck is going on? :bigyello:

Moved to Office Development.

Thanks for the move...sorry. I didn't see this forum listed when I posted.