Hi, agree with Micron that you might want to rethink your design. Made a few changes, seems like it does what you want but not sure. Also changed the...
I believe hyperlink syntax for Windows files is file:/// then the path. You're basically dealing with something that was meant for a browser, so file...
It's enough to just store the file path in the table field without formatting it a hyperlink and use code/macro to follow it - unless you're working...