Passing form value to hyperlink address

  • Thread starter Macro condition based on date
  • Start date
M

Macro condition based on date

How do I append a form field value to the end of a hyperlink address that is
coded as a hyperlink address on a form label?
 
A

Arvin Meyer [MVP]

"Macro condition based on date"
How do I append a form field value to the end of a hyperlink address that
is
coded as a hyperlink address on a form label?
Click to expand...

How about something like this in the form's Current event:

Private Sub Form_Current()
Me.lblWhatever.HyperlinkAddress = "C:\Data\" & Me.txtTextbox
End Sub
 
M

Macro condition based on date

Do not understand how this would pass (append) a filed value to the hyperlink
address when I click on the label that contains the hyperlink address.
 
A

Arvin Meyer [MVP]

By referring to the HyperlinkAddress property of a label in the form's
current event, you make that label into a clickable hyperlink. The label can
read anything, but when you click on it, it will link to the document at
C:\Data\ and whatever file name is in the textbox. If the resultant value is
not readable, it will open a Windows Explorer window to the default location
that Access has in its Options.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Macro condition based on date"
 
Top