I have a list with a rich text field where I need to allow users to paste UNC paths to files on a network drive, as hyperlinks.
The user can navigate to the network file and shift+right-click and ‘copy as path’, paste the value into the text field and poof! It’s a clickable link, as long as there are no spaces in the name. It will paste something like this: “\\server\folder\filename.ext” with the quotes.
Problem: The file structure on the server has thousands of files and folders, most with spaces in the names.Â
I have an Access 13 DB linked to this list and have developed a method to let the user browse to the file, select it and then replace all the spaces with %20 then copying it into the list field through the linked table in Access. (I also have enhanced rich text fields, but cannot paste to them as they show up in Access linked table as read-only)
That works great except for when I go to the Sharepoint site and find the list item and click the link, I get errors where the %20 seems to be recognized as %2520.Â
This is a really cool application that will fit our needs tremendously IF I can just get the link to open the file!
Any help or direction would be greatly appreciated. I am running out of time on this project!
Thanks,
Keith
You store rich text in a field that uses the Memo data type. This is the only data type that has built-in support for displaying and storing rich text. To create a field that can store rich text, you first create a memo field and then set the TextFormat property of the memo field to RichText.
Create a memo field to store rich text
Click the Microsoft Office Button and then click Open.
In the Open dialog box, open the database to which you want to add the field.
In the Navigation Pane, right-click the table to which you want to add the rich text field, and then click Design View.
In the table design grid, locate the first empty row. Then, in the Field Name column, type a field name.
In the Data Type column, select Memo.
Under Field Properties, click the General tab.
Click inside theText Format box and select Rich Text.
To save the table, click Save on the Quick Access Toolbar.
