[AccessD] Option Explicit

jack drawbridge jackandpat.d at gmail.com
Sun Nov 7 15:31:44 CST 2021


How do you add Option Explicit in VBA?
*Activate Option Explicit in VBA*

   1. First, open the Visual Basic Editor and in the tools menu click on
   the options.
   2. After that, in the options in, go to the editor tab and tick mark
   “Require Variable Declaration”.
   3. In the end, click OK.
   4. Once you do that, VBA will add option explicit whenever you add a new


On Sun, Nov 7, 2021 at 4:28 PM Arthur Fuller <fuller.artful at gmail.com>

> I recollect that there is a setting that automatically includes "Option
> Exlcit" whenever I create a new module, but cannot find it in Access 365.
> I'm tired of typing it again and again.
> Can anyone tell me where it is?
> --
> Arthur
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

More information about the AccessD mailing list