When I add a new button to a form and choose to use a wizard, the
resulting code is in the form of a macro. Is it possible to get
Access to create VBA code instead?

Macros in A2010 may be better than those in A2000 but I still prefer
to have all my code in VBA. I am more familiar with it and all the
code for a module is in one place.

"Jim Devenish" wrote in message
news:bfbd37d8-0447-4b4d-95a2-9fceda9190db (AT) r21g2000yqr (DOT) googlegroups.com...

There is a option to convert the macro to VBA once you created the macro
(bring up macro in editor, you see the option upper left in ribbon).

At the end of the day to my knowledge you cannot change this setting.

And I think like most here, we wish and prefer the wizards would create VBA.


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Pleasenospam_kallal (AT) msn (DOT) com

On Sep 20, 9:38*pm, "Albert D. Kallal" <PleaseNOOOsPAMmkal... (AT) msn (DOT) com>
wrote:
Hi Albert, you'd almost think somebody at MS initially planned to
allow us to select our preference.

I'm in A2007 and if I go to Access Options and select the Object
Designer option I see, under Forms & Reports, a checkbox for "Always
use event procedures." I'm sure there is an obfuscated description of
that checkbox somewhere buried under mountains of internet
information. I don't want to waste my time hunting for its
explanation. I'll simply accept the fact that the checkbox doesn't do
anything and accept the fact developers have to manually change it
from the default "embedded macro" to "event procedure as a part of
life.

Patrick Finucane <patrickfinucanetx (AT) gmail (DOT) com> wrote in
news:57f1d39e-8a62-4198-92b3-39f86870eb46 (AT) de2g2000vbb (DOT) googlegroups.co
m:

What it does is that when you click on the ... "builder" button in
the event properties sheet, it takes you directly to the VBE,
instead of dropping down a menu where you choose whether to use a
macro or code.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/