[AccessD] Option Explicit

Bill Benson bensonforums at gmail.com
Tue Nov 9 00:54:13 CST 2021


While there you might want to uncheck the auto Syntax check if it annoys
you as much as it annoys me. I don’t need VBA telling me what my typo has
wrong with it I can deal with the red text.

On Sun, Nov 7, 2021 at 11:48 PM Arthur Fuller <fuller.artful at gmail.com>
wrote:

> Thanks, Jack!
>
> On Sun, Nov 7, 2021 at 4:32 PM jack drawbridge <jackandpat.d at gmail.com>
> wrote:
>
> >  Arthur,
> >
> > 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
> >    module.
> >
> > jack
> >
> > On Sun, Nov 7, 2021 at 4:28 PM Arthur Fuller <fuller.artful at gmail.com>
> > wrote:
> >
> > > 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
> > >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> --
> 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