VBA: option compare

The option compare statement controls how strings are compared:

In order to compare strings case insensitively, the statement needs the text «argument»:

option compare text

In order to compare strings case sensitively, the statement needs the boolean «argument». (This is the default).

option compare boolean

In addition, VBA code that is written for Access also allows to declare database which uses the database's setting:

option compare database