[RESOLVED] Command Button hyperlink property from Record

[jtnelso]

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?

[RobDog888]

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.

[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.

[RobDog888]

Is your form an Access form too then?

[Hack]

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.

[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.

[Hack]

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?

Moved to Office Development.

[jtnelso]

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