Hyperlink question

  • Thread starter Thread starter Christophe Schoofs
  • Start date Start date
C

Christophe Schoofs

Does anyone know how I can change the text of a hyperlink field (in a form)
from the actual link to a title I choose?
for example: www.google.com is the actual link stored in the database, but I
want it be shown as "My Search Engine" in the form...
Any suggestions?

Thanx!
 
Right-click the hyperlink, and choose edit.

If you want to do this in code, use HyperlinkPart().
 
Access 2002

In a Hyperlink Object, you use the TextToDisplay Property for this purpose.

If this hyperlink is on a label, picture, or command button, use the
Hyperlink Property to reference to the Hyperlink Object.
 
Just learned through the help file, a hyperlink could be entered as follows,
such as in a field within a table or in a combo/list box:

"[<TextToDisplay>]#[<Address>]#[<SubAddress>][#<ScreenTip>]"

Example:

"Depend on Access
2003#http://www.microsoft.com/office/preview/editions/access.asp#section2#Im
provements to Access 2003"

Note, the first 2 pound signs are required, and the third one is only used,
if including a screen tip with it. Of course, as it would only make sense,
either the Address or SubAddress must be entered else an error occurs.
 
Back
Top