*LIKE * sytntax with an IF statement

[ruthcali]

For an IF Statement, what is the syntax for *like*

I've tried so many combinations of:

IF txtField like '*" & Me.stringField & "*'
IF txtField like " & "'" & "*" & me.stringField & "*" & "'"
IF txtField like " & "* & me.stringField & *"

But nothing works!!
(StringField is a string)

Thanks

 

[coco86]

If you're creating a conditional statement based on a textfield, you probably want to do something like:

IF instr(1,txtfield,me.stringfield,vbTextCompare) then

If you're building a query, don't use "IF" use "WHERE"

 

[JimInKS]

You could use Instr for this:

if instr(1, txtField, me.stringField, 1) <> 0 then

 

[ruthcali]

Thanks to both of you for writing.

I can't use Instr because of the following:

My string being searched is a memo field.

My string expression sought is all the employee names separated by commas:
&quot;Jones, Anderson, Smith, Lake, Johnson&quot;

So if Mr.Smith's name shows up anywhere in the memo field, the IF statement will be true.

So i thought i should use *LIKE*, but i can't get the syntax straight.

Thanks,