Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
Home > TechHelp > Directory > Access > Hyperlinks < Intro to VBA | Concatenation >
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   4 months ago

Hyperlink Fields & Why You Should NOT Use Them

 S  M  L  XL  FS  Join Now

In this video, I'll show you how to use the Hyperlink Field data type in your Microsoft Access tables. And... I'll explain why you should NOT use them. I'll show you a better alternative using plain Short Text fields, and how you can still make buttons to easily navigate to those hyperlink destinations.

Brent from Tracy, California (a Gold Member) asks: I have a list box where I am trying to change the font color. I have selected the list box in design mode and selected the color I want on the ribbon and all but one column changes to the color I pick. The one that doesn't change color is a field that holds emails and is a hyperlink field. How can I force all fields to be the same color?


Members will learn how to deal with web page addresses that may or may not have http:// in front of them. I will then show you how to FIX a database that may have been made with Hyperlink fields. To do that, we will learn how to tear apart the complex Hyperlink field type into its individual components with the HyperlinkPart function. We will then use an update query to copy the actual Hyperlink to the appropriate text field. 

NOTE: Members, I mentioned in the first video that I would show you how to browse and pick a file with a button. I totally forgot to do that in this Extended Cut, BUT I did cover it previously in my Images video.

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to contact me so I can set up your account here on my web site. If you're not a member, Join Today!


Learn More

FREE Access Beginner Level 1
Access Level 2 for $1.00

Free Templates

TechHelp Free Templates
Blank Template
Contact Management
Order Entry & Invoicing
More Access Templates


Mailing List - Get Emails When New Videos Released!
Consulting - Need Help with Your Database?


Please feel free to post your questions or comments below or submit them via the TechHelp page.


microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, ms access hyperlink field, hyperlink color, display text, hyperlink to file, hyperlink button, hyperlink to open, hyperlinkpart, hyperlink alternative


Buttons Continuous Forms Upload Images   Link  
Larry Fisackerly 
2 months ago
I implemented the concepts in Hyperlinks Fields and Why You should NOT use Them on the CustomerF. Such a valuable video!

On my CustomerExtendedF, I have a continuous SubForm for multiple documents and a continuous SubForm for multiple email addresses. How do I implement the launch Go button concept on the continuous forms? Read More...
Add a Reply
Split FilePath and Name Upload Images   Link  
Hezi Cohen 
4 months ago
Hi Richard
I would like to create a table which contain the folder path and the file name in a separate text fields. So If for some reason I need to change the folder of the saved files I can do so quit easily by using an update query. my question is if there is a way to split the file path in to 2 sections, one will contain the folder and the other will contain the file name, Read More...
Scott Axton
4 months ago
Hezi -

Having two separate fields isn't an issue.  You will have to concatenate them in your code.
FolderPath &"\"& FileName

You could hard code it in. Or you could set it in a field.  Personally if it was me I would NOT put it in every record as it's own field unless the FolderPath is different for each person for instance.

If it was me, and the files were always stored in the same place, I would create a "SettingsT" where you had the FolderPath stored.  Then use DLookup in your code to fill in a variable for FolderPath.

That way if the FolderPath ever changes you only have to change it in one place.  You don't have to worry about updating the path in all of your records.

I see that you have started the beginner series so I don't know if I just talked way over your head.  Let me know if so and I'll provide you some video links to get you going.

Add a Reply
Hyperlinks Upload Images   Link  
Brent Rinehart 
4 months ago
Richard thanks again ones more question to clarify in the extended video after converting all the emails in the table with an update query this would not prevent future emails being converted into the same format unless you run the update query again right? So I am assuming you are recommending running the update query on the current records then changing the hyperlink field in the table to a text field for future emails?
Adam Schwanz
4 months ago
Right, after you change the datatype and update everything over, start using that new field and delete the old hyperlink one.
Brent Rinehart
4 months ago
Perfect Thank You Adam
Add a Reply

Show Older Comments...
View in Table Format

Start a NEW Conversation
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

You may want to read these articles from the 599CD News:

11/30/2021Import Multiline Cells
11/30/2021Adam's Access Games
11/29/2021Prevent Close
11/22/2021Currency Symbols
11/13/2021Access Developer 36
11/13/2021Access Developer 36 Lessons
11/13/2021Access Developer 36
11/13/2021Control Tip Text
11/11/2021Link to Excel

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Account Login
Online Theater
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: TechHelp Access ms access hyperlink field, hyperlink color, display text, hyperlink to file, hyperlink button, hyperlink to open, hyperlinkpart, hyperlink alternative  PermaLink