Creating a hyperlink in a text box

[ThePolymathicMonk]

I have an employees database that imports and exports a memo field and
actually gives each file a different name programmatically, based on the last
name of the employee. Through string concatenation, I am able to set the the
file path for the text export to "C:\(EmpLName).txt" this is in my code as
strCompPath and so is available. I want to give the user the ability, via a
hyperlink, to go straight to the file they have just exported. I created an
unbound textbox with the IsHpyerLink property set to yes, and set the text
box's ".Value" to my strCompPath. When I look at the form in form view, the
text is there, in blue, but the hyperlink does not work. When I right click
on the box in design view, the "hyperlink" property is shaded out. What am I
missing?

 

[Allen Browne]

Did you build the compete 3-part hyperlink text, with the 2 # separators in
it?

If you're not sure what that means, see:
Introduction to Hyperlink fields
at:
http://allenbrowne.com/casu-09.html

An alternative might be to use the Click (or DblClick?) event of the control
to FollowHyperlink.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...