Trying to find unmatched data

[Tiny bird]

Now this may sound like a stupid question to some.........

I'm trying to write an If statement to check a field name if it doesn't contain a word within it

I've tried

If [FieldName] not like "%Maxflow%" Then

and
If [FieldName] not like "*Maxflow*" Then

and tried using notlike

I get a compile error telling me it's expecting an expression. I have used the like version of this and it works.

Am I missing something really obvious?

Many thanks

 

[FoFa]

dim ChkIt as Integer
ChkIt = Instr(1,VartoCheck,"Maxflow")
If ChkIt = 0 then
'did not find it
else
'found it
end if