hyperlink to be added but the texbox

[sdcrn09]

Is there a way to get the hyperlink to be added but the texbox to show only the title of the document it's linked to?

Private Sub browse_Click()

Me.[your_location].SetFocus
On Error GoTo browse_stop
RunCommand acCmdInsertHyperlink
browse_stop:

End Sub

reference:

http://bytes.com/topic/access/answers/721582-how-do-i-create-hyperlink-button-form

[zmbd]

Take a look at the following:

Microsoft's instructions

http://office.microsoft.com/en-ca/access-help/create-a-hyperlink-HP005188821.aspx

and something that humans can actually use and understand:

http://allenbrowne.com/casu-09.html

-z