Hyperlink Location

[Mahendra1000]

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.

[ItsMe]

Hide your textbox if you don't want the users to see it.

create a control button that is named "cmdLink"

In the control button's click event paste

dim strLink as string

strLink = me.location.value

cmd.HyperlinkAddress = strLink

should work