Using the 'Like' Command in Visual Basic

[TZyk2003]

Good morning!

I have a field that I'd like to suppress if it contains certains text values.

The problem is it may contain one text value or many text values seperated by commas.

What is the syntax for doing a "Like" command (like in SQL) in Visual Basic?? I can't simply do an "=".

THANKS!

-Tim

 

[dhookom]

You can use Instr() to find out if one string contains another.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[TZyk2003]

Thanks! I'll try that!

-Tim