Find and Replace hyperlink address w/Text to display Access 2013

[funwithaccess]

Hi everyone,

In the Access Table, how does one Find and Replace part of the hyperlink if the Text to display is different?

Example of Hyperlink Editor:

Example of Find and Replace

In other words, I'd like to find \\\FAKESERVER\ and replace it with C:\Users\ in all 1000 records. Is there any possible way to do this if there is Text to display?

 

[spikepl]

Not AFAIK. Create an update query, and use the HyperlinkPart method (look it up in the docs) to change the offending part.

I hardly ever use fields of Hyperlink type, because you can accomplish the same thing using a normal text field (or two) and the FollowHyperlink method

 

[vbaInet]

Hyperlink and Alias as field names is a bad choice.

Convert the hyperlink field to text and you'll see the different parts, i.e.
[Hyperlink] & ""

 

[funwithaccess]

Hyperlink and Alias as field names is a bad choice.

Convert the hyperlink field to text and you'll see the different parts, i.e.
[Hyperlink] & ""

Thank you, saved me a ton of time!

 

[vbaInet]

No problemo!