Software

Bypass the Choose Builder dialog box when coding events in Access

If you work only with event procedures, you can save yourself some time by making this small tweak in Access options.

Whenever you click the Builder button in an Event property box, the Choose Builder dialog box displays, forcing you to specify how you will build your code (Figure A).

Figure A

Choose Builder dialog

If you work exclusively with event procedures, you probably don't want to have to choose Code Builder each time you write or edit event code. You can make Code Builder the default by following these steps:

  1. Go to Tools | Options. (In Word 2007, click the Office button and then click the Access Options button.)
  2. Click the Forms/Report tab. (In Word 2007, click Object Designers and scroll to Forms/Reports.)
  3. Select the Always Use Event Procedures check box and then click OK.

Now when you click the Builder button, it will go directly to the Visual Basic window.


Miss an Access tip?

Check out the Microsoft Access archive and catch up on other Access tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks