Hyperlink field in a table

We have a hyperlink field set up to link to documents in a specific folder,
do to some issues we have to change the name of the folder. With changing
the name of the folder it makes us have to change the path of all the
hyperlinks (there is about 2000, so manually going in and editing them would
be a big hastle). In the field, we have the title stored and if you click on
that it takes you to the document. Is there an easy to change the names of
all the paths?? Is there a way to display the path to the hyperlink in the
filed, so I may do a find/replace??

Any help would be appreciated.

Roger

Have you tried using the Replace choice on the Edit menu? You should be
able to use the "...any part..." choice to find something (your pathname)
within the string in the hyperlink field.

This should give you a global search/replace capability for that field.

Good luck

Jeff Boyce
Access MVP

"Roger" wrote in message
...
We have a hyperlink field set up to link to documents in a specific
folder,
do to some issues we have to change the name of the folder. With changing
the name of the folder it makes us have to change the path of all the
hyperlinks (there is about 2000, so manually going in and editing them
would
be a big hastle). In the field, we have the title stored and if you click
on
that it takes you to the document. Is there an easy to change the names
of
all the paths?? Is there a way to display the path to the hyperlink in
the
filed, so I may do a find/replace??

Any help would be appreciated.