Hyperlink or URL In Table and Forms (1 Viewer)

[jms3257]

Not sure if this should be here in "Tables" or "Forms" but here goes. DB I'm creating will have quite a number of web addresses, and will be sorted by "Team Type" Sport Type" Gender Type" and "Level Type" (ie: Varsity, JV, Freshman) These will be in a table. Would I be better off storing as a hyperlink, or URL? Or does it matter one way or another? In the Main Form I will have command buttons to go to the different websites, if that matters in the choices.

Thank You
Jim:

 

[theDBguy]

Hi Jim. If it's just going to be URLs, my vote would be to store them as Plain Text.

Text or Hyperlink

This is a topic of discussion that I have participated in the forums a number of times in the past and will probably continue to engage in t...

thedbguy.blogspot.com

 

[June7]

I never user Hyperlink type field. Also vote for simple Text type field. Either way can be worked with as long as you understand the difference. Review https://stackoverflow.com/questions/61784169/ms-access-email-table-hyperlink/61784596#61784596

How do you plan to use command buttons with data in table?

 

[Eljefegeneo]

I am just a amateur at all the programming nuances, but I found early on that trying to edit email and web pages was exasperating, especially for the users who didn't understand why when they tried to edit either of these fields that they were ending up sending unwanted messages or going to unwanted we pages. So I always made them text fields and used the following for web pages or email:

'--Error Handling
On Error GoTo ErrorHandler
'WebPage is no longer a hyperlink, this code will bring up the web page
Dim WebLink As String
    If Me.WebPage Like "http://" & "*" Then
        WebLink = Me.WebPage
ElseIf Me.WebPage Like "https://" & "*" Then
    WebLink = Me.WebPage
Else
    WebLink = "http://" & Me.WebPage
End If
    'Debug.Print WebLink
        Application.FollowHyperlink WebLink, , True    
ErrorHandler:
If Err.Number = 87 Then
MsgBox "This Is Not A Valid WebLink"
End If

And

Dim olApp As Object
Dim mItem As Object
Set olApp = CreateObject("Outlook.Application")
Set mItem = olApp.CreateItem(0)  ' An Outlook Mail item
Dim DateE As String
Dim MsgR As String
' Add the To/Subject/Body to the message and display the message
With mItem
    .To = CStr(Me.Email)
    .Display    ' To show the email message to the user
End With
' Release all object variables
Set mItem = Nothing
    Set olApp = Nothing

And always used the double click to use them as only one click would be the same as if they were hyperlink fields.