How to convert a string into a hyperlink

[Guest]

I'm picking up a file name from a text field in a form and a foldername from
a query, merging it to something like "myfolder/myfile.doc" and
insert it into a table filed file_location as hyperlink. The field is
formated as
hyperlink.
This hyperlink is used to open the word document.
The insert is working fine, the inserted value is shown as hyperlink, but
word isn't opening when clicking on this link.
Is there a funtion to convert the string in the beginning into a proper
hyperlink?

Thanks in advance

jokobe

 

[Guest]

just for the documentation:
solved the problem with

new_name = "#myfolder/myfile.doc#"

 

[Keith Wilby]

I'm picking up a file name from a text field in a form and a foldername
from
a query, merging it to something like "myfolder/myfile.doc" and
insert it into a table filed file_location as hyperlink. The field is
formated as
hyperlink.
This hyperlink is used to open the word document.
The insert is working fine, the inserted value is shown as hyperlink, but
word isn't opening when clicking on this link.
Is there a funtion to convert the string in the beginning into a proper
hyperlink?

How are you performing the insert? Could it be that what you're inserting
is display text rather than the link itself?

Regards,
Keith.
www.keithwilby.com