Hyperlink Help

[elead]

I need some help with a hyperlink field

I have a field (szFilePath) that holds a relative path to a file on the
harddrive . The field type is hyperlink I want to open the file in the
hyperlink from a form in access


The value showing on the form from the database is like
c:\myfolder\myfile.txt, it's formatted as a hyperlink but does not open the
file...what do I need to do here?

thanks