Compare strings between 2 TextBoxes

[gabriel]

I am creating a password form.
I have 2 TextBoxes that need to be compared.
I currently have the following:
if Not tb1=tb2 then ...
The problem is with case sensitivity.
Currently, "John" will equal "john"
How do I check that "John" is not equal to "john"

Thanks

 

[rkc]

I am creating a password form.
I have 2 TextBoxes that need to be compared.
I currently have the following:
if Not tb1=tb2 then ...
The problem is with case sensitivity.
Currently, "John" will equal "john"
How do I check that "John" is not equal to "john"

Use the StrComp() function with the vbBinaryCompare option.