Does anyone know why is this at the top of some of some modules and not at the others

Option Compare Database

Thanks All

Does anyone know why is this at the top of some of some modules and not at the others

Option Compare Database

Thanks All

You have two choices, either Option Explicit or Option Compare. The Option Compare would be used if you wanted to do comparions, for example, between strings:

"AAAA" = "aaaa" would be false
"AbCd" = "AbCd" would be true

Just for clarification the following link shows results using different options:

http://support.microsoft.com/kb/98227/en-us

Option Explict can be set to add it self to everymodule when it is created. Higly reccomened as it stops a lot of silly mistakes.

from help

Require Variable Declaration — Determines whether explicit variable declarations are required in modules. Selecting this adds the Option Explicit statement to general declarations in any new module.

Peter