 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / May 2007Partial String Comparison
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? > 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? Look at the InStr() function.  Signature--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 > 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? On May 14, 10:53 am, "Roger Carlson" <RogerCarl...@noemail.noemail> wrote: > Look at the InStr() function. > [quoted text clipped - 16 lines] > > searching around and am surprised that VBA does not have such > > functionality built in. Does anyone have any suggestions? Thanks. That should work. I will try it. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.