Hyperlink Record

[RobVT]

Hey all, using MS Access 2000.

I've created a form that allows the database user to browse for and
insert the file path for a video library of sorts. I used the standard
"Browse" code located at http://www.mvps.org/access/api/api0001.htm.

That works just fine. However, once the hyperlink is input into my
table, I can not click on and follow that hyperlink from the actual
table or a query. I know it has something to do with the data type,
but I can't seem to figure out where I need to alter the code found at
the above-mentioned website in order to get the string inserted as a
hyperlink.

Has anyone else had troubles with this same thing? According to the
sources on here, the fix for it is to add a "#" to each end of the
string, but that's of little use when I don't know where the string is
called out.

Thanks in advance!

Rob

 

[Guest]

To change the data type in your table open it in design view. Change the data
type for that particular field to hyperlink.