[SOLVED] case-insensitive text

Hi all,



Is there a way to use "Option Compare Text" along with Option Compare Database and Option Explicit?

I use the below code:

Code:

---

If Me.Business = "TYPE 1" And Me.Case = "Sent Email" Then

---

But if "TYPE 1" is writen as "Type 1" it will give error mismatch.



Any ideas?



Greetings

[SOLVED] case-insensitive text