Full Version: 2nd Hyperlink Issue...
UtterAccess Discussion Forums > Microsoft® Access > Access Forms
sredworb
Hello,
That 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.
o 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...
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.