How to create a clickable URL link

I have a DB which uses a stored form. One of the fields on the form has an editable text field which contains this formula as the default ; “http://servername.abc.com/pagename” & fieldname.The field appears as plain text, but after a user forwards the document the field becomes a URL link which you can click to go to the desired URL. The question is how can I create a clickable URL link on the form that will work both before and after the document is forwarded? I tried a URL Hotspot, but this has the opposite problem, the link works initially but not after the document is forwarded.

Thanks

Subject: How to create a clickable URL link

try changing the field type from Text to Richtext

Subject: RE: How to create a clickable URL link

That almost works. When the document is created by an agent the new RT field does not display as a URL link. If I edit/save the document the RT field does change to a clickable link.

Subject: RE: How to create a clickable URL link

It has to do with the way the text is added to the document. Post your agent code so I can see how you are creating it.

Do it like this:

Dim db As NotesDatabase

Dim ns As New NotesSession

Dim memo As NotesDocument

Set db = ns.CurrentDatabase

Set memo = New NotesDocument(db)

memo.Form = "Memo"

memo.Subject = "link to yahoo mail"

Set rtitem = New NotesRichTextItem( memo, "Body" ) 

Call rtitem.AppendStyle(ns.CreateRichTextStyle)

Call rtitem.AddNewLine(2)

Call rtitem.Appendtext("Link to yahoo mail --->  http://mail.yahoo.com")

Call memo.Send(False, "<recipient goes here>")

Subject: RE: How to create a clickable URL link

That did it!

Thanks