How do I make InStr case sensitive in MS Access?
I'd like the following to display 0
msgbox InStr("In Here", "here")
Instead I get 4.
I've tried adding vbBinaryCompare
msgbox InStr("In Here", "here", vbBinaryCompare)
but it complains about a type mismatch.