Hyperlink Not Working

[fastmike]

I have a form with a Command button. i have a text box also which is
bound to my
Button. i have created a standard module and created an onclick event
for my button
which is something like this ( if a user clicks on the button it will
give an option
to user to add a file. The Path of that file will be copied to the
textbox which is associated
to my control or button.) i changed the data type also for my textbox
to
Hyperlink so then
when a user clicks on that path which is in the textbox it will
automatically open that document. Well for
some reason it is not working. any
help or suggestions will be really appreciated.
Thanks

 

[Len Boorman]

When you create a Hyperlink sort of manually you needa # at the beginning and end.

so a type in hyperlink of \\server\folder\file1.xxx even typed into a Hyperlink defined field will probably not work


But #\\server\folder\file1.xxx# will work but when you actually look at it you will not see the #'s.

Had the problem myself creating hyperlink using a query to concatonate soem text strings and eventually found the fix

HTH

Len

 

[fastmike]

Hey Len. Thanks for replying. it works fine if i do it manually like put a # sign at the beginning of the text
and at the end of the text. but as you know my Path is copied to my textbox by the name of Attachments as i mentioned earlier so i am
assuming i need to create some kind of onclick procedure for my textbox Attachments so then when a user enter a file path through my button
and when he clicks on that textbox(Attachments) it should automatically go to that page through that Onclick Procedure or Macro. any suggestions
on what kind of procedure can we build ? Thanks for your help Len.

 

[fastmike]

i got it. this is the procedure i creared and worked fine.

Private Sub Attachments_Click()
Application.FollowHyperlink (Attachments & "#" & txtLOC & "#")
End Sub

Thanks for all your help RG(Rural Guy) and Len