Hyperlinks

[TracyG]

I am using hyperlink fields stored in "text" fields in a table. How can I
force the hyperlink to store the whole path and filename rather than info
such as:
Reports\sh3 logo black.JPG#Reports/sh3%20logo%20black.JPG#

The field is used between multiple users, so the full network path name
needs to be stored with the file name if possible.

 

[Reddlief]

I am using hyperlink fields stored in "text" fields in a table. How can I
force the hyperlink to store the whole path and filename rather than info
such as:
Reports\sh3 logo black.JPG#Reports/sh3%20logo%20black.JPG#

The field is used between multiple users, so the full network path name
needs to be stored with the file name if possible.


I've just "cut and pasted" the URL displayed in my browser to the field in my database for storage. I don't store it as a text file, but as a hyperlink. Doing so, not only creates a live link, but allows editing for display of what you intend.