• VBA from Control Wizard (Access 2007)

    Author
    Topic
    #453525

    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?

    Viewing 1 reply thread
    Author
    Replies
    • #1123463

      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.

    • #1123462

      See John Hutchison’s reply.

    Viewing 1 reply thread
    Reply To: Reply #1123463 in VBA from Control Wizard (Access 2007)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




    Cancel