Full Version: 2nd Hyperlink Issue...
UtterAccess Discussion Forums > Microsoft® Access > Access Forms
sredworb
Hello,

What I am trying to figure out is a way to say Paste (copy and paste), a web address into a control box and when it is displayed it displays a single word that basically is the hyperlink.

eg...

copy and paste; http://www.utteraccess.com
displayed as Utter Access

I have alot of hyperlinks to add and I am trying to find a faster way than adding #Text then Hyperlink...

Is there a way I can put the Utter Access as the default display and then add the hyperlink?

Another example is this...email address..

copy and paste..jerry@jerry.com / Displayed as E-Mail

Any suggestions.

Jerry
dannyseager
Well I think you first need 2 fields... one for the hyperlink and one for the descriptive name.

To get the descriptive field should be relativly easy to get it basic.... you can use the replace function to change what is pasted.

Something like
CODE
If instr(HyperlinkField,"@")>0 then
    Descriptivefield="E-Mail"
else
    Descriptivefield=ConvertHyperlink(StrHyperlink)
end if

Public Function ConvertHyperlink(StrHyperlink as string) as string

ConvertHyperlink=StrHyperlink

Dim StrStripOut as string
StrStripOut="http://,.com,.co.uk,.net,.org"

for i = 0 to len(StrStripOut)-len(replace(StrStripOut,",",""))-1
    ConvertHyperlink=replace(ConvertHyperlink,split(StrStripOut,",")(i)
Next i
end function


Please note this is completly untested but should get you started.
sredworb
Hi Danny,

Can't seem to get it to work...

Thanks..

Jerry
sredworb
Any chance I can get you to add it to this sample db...

I can't get it...

Jerry
dannyseager
Well I am now hoping I have understood the question

See attached
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.