Partial String Comparison

[jdberman]

Hello. I have a field in a form that I want to check whether it is a
hyperlink or not. I was thinking I could just check if the string
contained "http://" or "https://", but I could not find a way to see
if a partial string is contained within a string. I have been
searching around and am surprised that VBA does not have such
functionality built in. Does anyone have any suggestions?

 

[Roger Carlson]

Hello. I have a field in a form that I want to check whether it is a
hyperlink or not. I was thinking I could just check if the string
contained "http://" or "https://", but I could not find a way to see
if a partial string is contained within a string. I have been
searching around and am surprised that VBA does not have such
functionality built in. Does anyone have any suggestions?

 

[Roger Carlson]

Look at the InStr() function.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[jdberman]

Look at the InStr() function.

--
--Roger Carlson
MS Access MVP
Access Database Samples:www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

Thanks. That should work. I will try it.