Find and Replace

[kitty77]

I'm trying to do a find and replace on a hyperlink field...

Find "\AMN\AMN\" and Replace it with "\PRO\PRO\"

Here is what the data looks like for find: \\SERVER\Test Folder Now\AMN\AMN\Results\19329.pdf
But when it replaces, it gives me this: file:///\\SERVER\Test%Folder%Now\PRO\PRO\Results\19329.pdf

Why is it putting the file:/// and "%" when it replaces? How can I fix this? Export it first?

Thanks!

 

[namliam]

The % is the official notation for a space in the hyperlink
File is because you are pointing to a file

The link should still work? Have you tried the new link?

Why do the replace in the first place?

 

[kitty77]

Thanks. Looks like if I copy into excel, then paste back into Access it works or views the same.
Why? Because the file location changed.

 

[namliam]

Well if your DB changed with it as well, perhaps you can use a relative filepath instead.

 

[Galaxiom]

The % is the official notation for a space in the hyperlink

Not quite.
The percent is an escape character. What follows it defines the character
%20 designates a space.

 

[namliam]

I stand corrected

 

[kitty77]

So, when I copy into excel, then back into Access, the data looks correct and formatted the way I'm looking for.
But the target for the hyperlink is not there?