RE: [MS_AccessPros] Textual Search

 

Hi Mike!

You can use the InStr function.

InStr(TextString, SearchString) will return the space where the search string starts. Of course this will also find words like searchable. InStr will return a 0 if the string isn't found.

Jeff Bridgham

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mithomas48
Sent: Friday, January 27, 2012 10:56 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Textual Search

Is there a simple way with a function or such to locate a text string within another text string? For example...

Text String 1 = "Need to search this string."
Search Criteria = "search"

So is there a quick and simple way to find the word "search" within Text String 1?

Thanks in advance!
Mike

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 7
• New Links 2
• New Files 7

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___