Hyperlink on forms
Bingo! Thanks Mate
"Lord Kelvan" wrote:
Sorry the datatype in the table needs to be text not hyperlink the #
around the hyperlink is ms accesses way of knowing it is a hyperlink.
To be honest the clicking of the hyperlink on a tab control works for
me but try this if you don’t want to modify your table
Application.FollowHyperlink Mid(mycontrol.Value, InStr(1,
mycontrol.Value, "#") + 1, Len(mycontrol.Value) - InStr(1,
mycontrol.Value, "#") - 1)
What this does is looks at the hyperlink and just grabs the text
between the # values
Regards
Kelvan
.
|