I have created a hyperlink field in my table (tbl_ChkRequests) using hyperlink datatype. The field shows the blue hyperlink but clicking on that field does nothing.
I manually added # sign both before and after the sting which allows the hyperlink to function. Hovering over the field with screen tips does not reveal the # signs I placed before and after the path.
I then created an update query to place the # signs before and after the path string. I ran the query but the resulting link does not work.
My table has too many records to manually manipulate the path field.
This is the update to criteria I used in my Update Query: UPDATE tbl_ChkRequests SET tbl_ChkRequests.Path = "#" & [Path2] & "#";
Can someone please advise how to create a functioning hyperlink field?
Thank you very much.
Hefly
I manually added # sign both before and after the sting which allows the hyperlink to function. Hovering over the field with screen tips does not reveal the # signs I placed before and after the path.
I then created an update query to place the # signs before and after the path string. I ran the query but the resulting link does not work.
My table has too many records to manually manipulate the path field.
This is the update to criteria I used in my Update Query: UPDATE tbl_ChkRequests SET tbl_ChkRequests.Path = "#" & [Path2] & "#";
Can someone please advise how to create a functioning hyperlink field?
Thank you very much.
Hefly