Alternate text for hyperlinks- can this be done?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to display alternative text for hyperlinks in forms? I don't
want the actual link to show in the form but rather something like "Click
here".

My hyperlink is in a text box on my form that refers back to the field in
the table. Not sure if this would make a difference or not...

Thanks for any help!!!
 
No matter whether it is a button or a label or a text box... try this
OnClick

Private Sub yourbutton_Click()
On Error GoTo Err_yourbutton_Click

Application.followhyperlink "Your Link"

Exit_yourbutton_Click:
Exit Sub

Err_yourbutton_Click:
MsgBox Err.Description
Resume Exit_yourbutton_Click

End Sub
 
Hi Jody,

If (a) by "alternative text" you mean a display value (e.g. "Microsoft"
for "http://www.microsoft.com", and (b) your textbox is bound to a
hyperlink field in the underlying table, then you can just store the
links in the table like this (the display text and subaddress parts are
optional):

[Display Text#]Address[#SubAddress]
e.g. Microsoft#http://www.microsoft.com

This is done automatically when you use the Insert Hyperlink command;
see also Help on the HyperlinkPart() function.
 
John I owe you so much!!! This is exactly what I've been looking for! I
couldn't find it so I was going to settle by changing things around some but
now I don't have to.
--
Thanks!
Jody


John Nurick said:
Hi Jody,

If (a) by "alternative text" you mean a display value (e.g. "Microsoft"
for "http://www.microsoft.com", and (b) your textbox is bound to a
hyperlink field in the underlying table, then you can just store the
links in the table like this (the display text and subaddress parts are
optional):

[Display Text#]Address[#SubAddress]
e.g. Microsoft#http://www.microsoft.com

This is done automatically when you use the Insert Hyperlink command;
see also Help on the HyperlinkPart() function.

Is there a way to display alternative text for hyperlinks in forms? I don't
want the actual link to show in the form but rather something like "Click
here".

My hyperlink is in a text box on my form that refers back to the field in
the table. Not sure if this would make a difference or not...

Thanks for any help!!!
Click to expand...
Click to expand...
 
Back
Top