Codes modules should include Option Explicit by default

[Dale Fye]

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]]

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
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

 

[Dale Fye]

Thanks, Jeff

Knew it was there somewhere, but couldn't remember where.