Bulk Update of Hyperlink Text to Display, not hyperlink

[friedboudinball]

i have thousands of data records with hyperlinks that are correct. Each data record shows the actual link (google.com, foxnews.com, espn.com, etc.). However, i want to change all of the records to just say "link" instead of saying espn.com, etc. How can i do this automatically without having to manually right click, edit, and changing the text to display?

 

[BlueIshDan]

You want to update all records in a table to say "link" or update a form to say link in a text box?

 

[friedboudinball]

Dan is the man today!

i want the table record to say "link" instead of "google.com". Basically, i want to figure out a way to update al the records automatically instead of having to right click on each data record in the table, going to text to display and typing "link".

 

[BlueIshDan]

Are you familiar with sql at all?
Run an update Query
SQL - UPDATE

 

[friedboudinball]

yes, i know how to do the update ... i jsut don't know how to update ONLY the Display Text and not the entire hyperlink.

 

[BlueIshDan]

yes, i know how to do the update ... i jsut don't know how to update ONLY the Display Text and not the entire hyperlink.

Could you give me a screenshot of what it is you are looking at lol

 

[Neil Bingham]

Have had similar problem - I have table with details and file names of 10,000+photos and now wanted to bulk hyperlink them. I created a hyperlink field in the table. I then made a form to show all fields.
I entered a hyperlink to first photo in the first record (right mouse - or SHIFT F!0 - , Hyperlink, Edit Hyperlink)
I then made a macro for 'On Click' event in hyperlink field of form.
Macro : RunMenuComand - HyperlinkDisplayText
Now when you go to first record on form and click Hyperlink field you will see the text string of name you have given plus file path enclosed in #
ie field now shows text detail and you will see it is also followed by #file location#. Now you can create an update query on your table - update field to "The text you want to see#complete file path of relevant file" (ie in my case the Field [File Name] which is the file name field in my table) Make sure that file name includes extn.
Example - update to "My USA Pix#[File Name]#" ([File Name] in first record was E:\California\001)
Maybe too late to assist you but hopefully will help others. The key to this is being able to see what text Access actually has in a hyperlink field - the macro on the form does this and shows the name you have given for the link followed by file path (enclosed with # either side - no spaces!)
You will hopefully be able to make an update query to amend whichever part you wish - either the name or the file location.