Hyperlink Location

[Mahendra]

I have a field named Location of type Hyperlink. I have copied the respective filepaths in those location column.

The location filed looks like

M:\New\1234.pdf
M:\New\1111.pdf
M:\New\2222pdf
M:\New\4444pdf

If the user clicks on this link then the respective file should be open

I don't want the front end users to see the entire path. So, I would like to have the names as 1234.pdf in the location column instead of M:\New\1234.pdf. Is it possible to hide the entire path in the backend and show only the name of the file. so that if users click on 1234.pdf then the file needs to open.​

 

[Mr Smin]

If the file names all follow the same pattern you can use the Right function to only show the last 8 characters of the path
http://www.techonthenet.com/access/functions/string/right.php

but this won't work if the files have names of different lengths, in which case you might use a Regular Expression to identify everything after the last \ character.

 

[spikepl]

Don't use hyperlink but normal textfield. Hide your path of the directory wherever you wish, and construct the full path on, say, doubleclick of the textbox, and use Application.FollowHyperlink to open your file.