Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
When you enter in web site URLs or e-mail addresses, Access will automatically underline them, color them blue, and turn them into hyperlinks. This is useful for quickly jumping to the Internet or making new e-mail messages. But if you're just looking at the data or needing to print, all the formatting can be distracting. Here is how to remove automatic hyperlinking. I am in my Customers table, and I am scrolled over to the right so that I can see the Web Page and Email Address columns. You'll be tempted to use the same technique that you might use in Word.
To right-click on the link, go down to Hyperlink, and choose Remove Hyperlink. But in Access 2010, for some reason, this erases the entire field. I will press Escape on my keyboard so that this error doesn't get saved. The only way to turn off the formatting is to not use the hyperlink field type. I will go up to the Customer's tab, right-click on it and change to Design View. I will scroll down and click on WebPage and I will change the data type from Hyperlink to Text and I'll do the same thing for EmailAddress; change Hyperlink to Text.
Now when I go back to the Customers table tab and right-click on it, I will go back to Datasheet View, it will ask if I want to save my changes and I certainly do. I get a message that says, some data maybe lost, but that's okay, I'll click Yes. Now when I scroll over to the right, my Webpages and my Email Address are plain text. But do note that I no longer have any interactivity. If I want to go to the Webpage or start an e-mail to that person, I now need to highlight the data, then copy and paste it into my browser or new e-mail message.
Whether you choose to remove the automatic hyperlinks, will depend if it will be more convenient to click on the links to communicate or to see the data in plain text.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 70716 Viewers
80 Video lessons · 127730 Viewers
52 Video lessons · 62588 Viewers
59 Video lessons · 48307 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.