[AccessD] Option Explicit

Gary Kjos garykjos at gmail.com
Fri Sep 10 12:55:01 CDT 2010


Go into the VB Editor and select Options from the Tools menu.

Ensure that the second check box ("Require Variable Declaration") on the
first tab ("Editor") is checked.

This will only change NEW modules created from that point onward.

GK

On Fri, Sep 10, 2010 at 12:29 PM, David McAfee <davidmcafee at gmail.com> wrote:
> In Access 2007, when I create a new form and go to the VBA window, I
> only see Option Compare Database.
> Option Explicit is missing, so I have to manually add it.
>
> Is there a setting that I can change somewhere to have that listed in
> all modules?
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Gary Kjos
garykjos at gmail.com



More information about the AccessD mailing list