How to default to Code Builder in 2007?

[diane]

I'm hurrying to error-check a bunch of in-house applications in Access
2007 before we roll it out to the whole firm in less than a month.
One of the time-wasters I'm encountering is having to select "Code
Builder" (as opposed to "Expression Builder" or "Macro Builder")
every time I try to add an event to an object.

Long, long ago I found out how to default this right to Code Builder
in Access 2003, but it's been so long I don't remember where it was,
and in any case I can figure out where to set the option in 2007.

Anybody find this yet?

[Allen Browne]

Check the box for:
Always use event procedures
under:
Office Button | Access Options | Object Designers

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"diane" <di***********@verizon.netwrote in message
news:11**********************@22g2000hsm.googlegro ups.com...

I'm hurrying to error-check a bunch of in-house applications in Access
2007 before we roll it out to the whole firm in less than a month.
One of the time-wasters I'm encountering is having to select "Code
Builder" (as opposed to "Expression Builder" or "Macro Builder")
every time I try to add an event to an object.

Long, long ago I found out how to default this right to Code Builder
in Access 2003, but it's been so long I don't remember where it was,
and in any case I can figure out where to set the option in 2007.

Anybody find this yet?

[diane]

Oh, thanks, I skipped right past the checkbox when I was looking!