Web Link in Forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Yes, I am somewhat new to this...

I am trying to create a dynamic web link on a form that is derived from
field data in an access table. For example, my table contains data such as:

Field Name=Colors
Field Value 1: red
Field Value 2: blue
Field Value 3: green

I tried to write an expression using a bound control such as this: ="http://
www.abc.com/" & [Colors]

I then set the "IsHyperlink" property of this control to: yes

The form displays the proper output i.e. http:// www.abc.com/red

However; when I place the mouise cursor over the link and click; the link
does not work.

Am I missing something?

Thanks,
 
Try somethink like this, using the Click event (air code):

Sub txtBoxName_Click()
Dim strPath As String

If Not IsNull(Me.txtBoxName) Then
strPath = Me.txtBoxName
Me.txtBoxName.HyperlinkAddress = strPath
End If
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
I could not get suggestion to work. I get a "Compile Error: Method or data
member not found (Error 461)" on the .HyperlinkAddress...?
 
Back
Top