|  | Codes modules should include Option Explicit by default | | |
| | | Dale Fye |  |
|  Posted: Thu Sep 04, 2008 5:45 pm Post subject: Codes modules should include Option Explicit by default |  |
I remember when 2003 came out, there was a checkbox somewhere that if it was
checked, an Option Explicit statement would show up in the declarations
section of all new code modules.
Where is this functionality in Access 2007?
--
HTH
Dale
Don''t forget to rate the post if it was helpful!
email address is invalid
Please reply to newsgroup only. |
| |
| | | Jeff Conrad [MSFT] | |
| | Posted: Thu Sep 04, 2008 6:44 pm Post subject: Re: Codes modules should include Option Explicit by default | |
Hi Dale,
With the VBE open:
1. Click Tools
2. Click Options
3. On the Editor tab, select the option called "Require Variable
Declaration"
--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET - XAS Services - Microsoft Corporation
Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
LINK
Access 2007 Info: LINK
----------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
LINK
----------
"Dale Fye" wrote in message:
news:D41EE08E-C6DF-4C36-9393-9EBAF2A4D702@microsoft.com...
| Quote: | I remember when 2003 came out, there was a checkbox somewhere that if it
was
checked, an Option Explicit statement would show up in the declarations
section of all new code modules.
Where is this functionality in Access 2007?
--
HTH
Dale
Don''t forget to rate the post if it was helpful! |
|
| |
| | | Dale Fye | |
| | Posted: Thu Sep 04, 2008 10:46 pm Post subject: Re: Codes modules should include Option Explicit by default | |
| |  | |
Thanks, Jeff
Knew it was there somewhere, but couldn't remember where.
"Jeff Conrad [MSFT]" <UseContactForm@mywebsite.com> wrote in message
news:%23ozaO8sDJHA.1184@TK2MSFTNGP04.phx.gbl...
| Quote: | Hi Dale,
With the VBE open:
1. Click Tools
2. Click Options
3. On the Editor tab, select the option called "Require Variable
Declaration"
--
Jeff Conrad - Access Junkie - MVP Alumnus
SDET - XAS Services - Microsoft Corporation
Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
LINK
Access 2007 Info: LINK
----------
This posting is provided "AS IS" with no warranties, and confers no
rights.
Use of included script samples are subject to the terms specified at
LINK
----------
"Dale Fye" wrote in message:
news:D41EE08E-C6DF-4C36-9393-9EBAF2A4D702@microsoft.com...
I remember when 2003 came out, there was a checkbox somewhere that if it
was
checked, an Option Explicit statement would show up in the declarations
section of all new code modules.
Where is this functionality in Access 2007?
--
HTH
Dale
Don''t forget to rate the post if it was helpful!
|
|
| |
|
|
