Q:

IN Function for Access VBA

Is there a function in Access VBA that works like the IN function in SQL?
I'm looking for something like:
if StringValue IN(strA, strB, strC) Then

A:

While sgedded's answer is correct, here's another way that I think is a little cleaner code.
Select Case stringValue 
    Case strA, strB, strC
        'is true statements
End Select

http://msdn.microsoft.com/en-us/library/gg278665(v=office.14).aspx

