I have a field on my form that stores a Hyperlink path to different files on the user's computer. (Word files, excel, etc)

The user wants to be able to click on the path & it automatically open the file.

Right now it just opens up a new tool bar & tries to go to the link as if it is a web address.

Is this possible?

Hi,
try this on the click event of the control bound to the hyperlink data type:

Me.YourHyperlinkControlName.Hyperlink.Follow

If you want to be a bit more flexible then convert the values to a text data type and just use code at runtime to execute/open them e.g. with the FollowHyperlink, Shell or ShellExecute methods.
HTH
Good luck