MS Access 2007 - Use Control Wizard

  • Thread starter Thread starter JohnG
  • Start date Start date
J

JohnG

In the past versions of MS Access, when creating a button on a form, with the
Use Control Wizard button enabled, VBA code was written. Apparently, Access
2007 automatically creates macros instead. Is there a way to revert back to
creating VBA code when creating a button with the Control Wizards enabled? I
have checked the Access Options, and maybe I missed it, but I did not find
any reference to this feature.
 
Hi JohnG,
the short answer is no.
There is a way to convert macros to code - you may be able to do that.
On the nav pane, choose a macro.
On the ribbon choose database options, then choose macro, convert macro to
code.
I haven't tried this, so I can't say what the code looks like after
converting.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
John,

The control wizards create Embedded Macros, which are new to Access 2007.
 
Jeanette,

You can use the facility you mentioned to "convert" all a form's macros in
one hit. So that has some appeal.

But the code does not come out as you or I would write the code. It is
often clumsy and ugly. And in the case of complex macros, the converter
sometimes just can't cope.
 
Thanks Steve for that info.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Back
Top