Hyperlink on forms

[hjgoldstein]

I have a silly problem which is baffling me.

I have two forms - one single form view, one continuous forms view.

The single form has a tab control.

I have a hyperlink text box control on the continuous form and an identical
one on the tab control of the single form.

The hyperlink on the tab control only works if the sub-menu item "Hyperlink

Open Hyperlink" is used. If I click on the control, the system inserts a

"#" before and after the url and then does nothing else. If I put the text
box control in an area of the form outside of the tab control, it works fine.

Any ideas?

 

[Lord Kelvan]

Don’t know the answer to your problem but I don’t use hyperlinks and
if you cannot find a solution to it you can try this

I don’t use the hyperlink I only store the path in my database

Ie

C:\programfiles\mydocuments\document.doc

Or

http://www.google.co.nz

I then assign this to a control and use onclick to run this code

Application.FollowHyperlink mycontrol.Value

Hope this helps

Regards
Kelvan

 

[hjgoldstein]

Thanks for your reply Milord.

I tried your suggestion (clever) but exactly the same occurs. I just can't
understand why the Tab Control doesn't like it. The strangest thing is the
"#" characters appearing at either end of the url when you click on it.

I'd appreciate any other suggestions from any of you genii.

Thanks.

 

[Lord Kelvan]

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

 

[hjgoldstein]

Bingo! Thanks mate.

 

[hjgoldstein]

Bingo! Thanks Mate