Button, Image or Lext Box to access "Hyperlink field"

[floyd]

I think this is easy.

I have a field in a Table (tblMainFile) named "FileLocation" which contains a hyperlink for each of the files.



Here is the problem / question

I have a continuous form (from a query) which displays information from the tblMainFile table.

As it stands right now, the form shows a textbox (with the hyperlink) which is clickable to take them to the link location.

I would like to have a button which says (GET FILE) or a different text box which simply says "Get File" as opposed to the entire hyperlink.

I know this is simple, but I can't figure it out and my searched have left me empty.

Thank you for the help.

[June7]

Is the field defined as a Hyperlink type? You can put whatever text you want into the hyperlink description part.

Review:
http://www.allenbrowne.com/casu-09.html
http://allenbrowne.com/func-GoHyperlink.html

[ItsMe]

In the new button's click event, where ControlName = New Button's Name and ControlWithPath = your text box with the full path

Dim strLink As String
strLink = Me.ControlWithPath.Value
Me.ControlName.HyperlinkAddress = strLink

[floyd]

Is the field defined as a Hyperlink type? You can put whatever text you want into the hyperlink description part.

Review:
http://www.allenbrowne.com/casu-09.html
http://allenbrowne.com/func-GoHyperlink.html

Where would I find this?
I have been in the FORM and TABLES and I can't figure out where this would go.

Thank you for the help!

[June7]

What are you looking for - the Hyperlink property of field or where to put code?

As ItsMe suggested, put code behind button in VBA click event procedure.

[floyd]

That worked PERFECTLY!!!!

THANK YOU!!!

[ItsMe]

Glad you got it solved