Override the Option Compare Text Statement

Category:
String Manipulation
Type:
Snippets
Difficulty:
Beginning
Author:
Intelligent Solutions Inc.

Version Compatibility:

More information:
When you have the Option Compare Text statement at the top of your module (meaning you want text comparisons to be case insensitive), there may be some times you want to override this and do a binary (case sensitive) text comparison. Here is a simple and re-usable function allowing you to do this.

Instructions: Copy the declarations and code below and paste directly into your VB project.

Declarations:

Code: