Hello, I have a field called "url" in my form. When saved to table, it needs to contain "h t t p : / /" (without the spaces!) before the user types the standard URL address, but field needs to be empty if no URL is entered. I can't figure out how to do this.
I've tried adding it as default text of "h t t p : / /" (also without the spaces!) but this fills in data all the time, and I've tried creating a checkbox to enable the text field (using VBA code below) but it doesn't seem to work either. Also tried using OnChange, but no luck there either. Is there a way to do this? Thank you!
I've tried adding it as default text of "h t t p : / /" (also without the spaces!) but this fills in data all the time, and I've tried creating a checkbox to enable the text field (using VBA code below) but it doesn't seem to work either. Also tried using OnChange, but no luck there either. Is there a way to do this? Thank you!
Private Sub Check60_AfterUpdate()
If Me.Check60 = True Then
Me.url.Enabled = True
Else
Me.url.Enabled = False
End If
End Sub
If Me.Check60 = True Then
Me.url.Enabled = True
Else
Me.url.Enabled = False
End If
End Sub