Searching String

baul14

Registered User.
Local time
Today, 16:33
Joined
Sep 17, 2003
Messages
10
hello all,

I have this table and one row contain bunch of texts. I have no idea how to search a string or character in a phrase.

for ex: one field of table contain this string:
"Hello World, I am here"

I want to search in this string the word "am"

Once it's find I can take the whole row and display it's infor in a form.

I am looking for a function that will help me to code this.


Thank you very much,
baul
 
Lookup the InStr() function.

i.e.


Code:
If InStr(1, MyString, "am") Then
 
Or if you're feeding the form using a query, you can search for the rows that contain "am" using an expression like this in the Critieria line:
Like "*am*"
 
is this function works with Access Coding, VBA? or is this only for VB?
 
opsss... i didn't read the last thread. hmmm... thanks guys
 

Users who are viewing this thread

Back
Top Bottom