VBA from Control Wizard (Access 2007)

Topic

New Reply

I note that when I create a new Control on a form using the wizard, Macro code is produced. I can then convert the Macros on the form to VBA. Is there a switch somewhere where I can have the Wizard create VBA Code as a default?

Reply | Quote

Replies

Yes this option is available.

Office Button..Access Options…Object Designers..Forms/Reports..Tick “Always use Event Procedures”.

PS I am not in front of 2007 at the moment – these instructions are copied from a book, so I hope they are right.
From memory they are.

Reply | Quote

See John Hutchison’s reply.

Reply | Quote

Thanks Hans, speedy reply as always. You are right, its dumb.

Reply | Quote

Ahh John, I was premature with my comments to Hans.

Many thanks. Has altered my view of Victorians. LOL

Reply | Quote

John & Hans,

John you were correct. It works fine now.

Reply | Quote

But I did grow up in Sydney!

Reply | Quote

Well in that case you can’t be all bad.

Thanks again

Reply | Quote

But see John Hutchison’s reply (I edited mine after seeing it)

Reply | Quote