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
.