Option Compare Database

[stephenj789]

I know what Option Explicit is, but when I open up the vba editor in Access I also see Option Compare Database. I've searched the web and have been unable to find out what it is, so I have come here. Could someone explain to me what it is and what it does? Thank you.

 

[sfreeman]

From the Help file:

If used, the Option Compare statement must appear in a module before any procedures.

The Option Compare statement specifies the string comparison method (Binary, Text, or Database) for a module. If a module doesn't include an Option Compare statement, the default text comparison method is Binary.
...
Option Compare Database can only be used within Microsoft Access. Option Compare Database can only be used within Microsoft Access. This results in string comparisons based on the sort order determined by the locale ID of the database where the string comparisons occur.



Sam_F
"90% of the problem is asking the right question.