Access Database Design and Programming, Second Edition

The Code Window

The Code window displays the code that is associated with the selected item in the Projects window. To view this code, select the item in the Projects window and either choose Code from the View menu or hit the F7 function key. For objects with only a code component (that is, standard or class modules), you can just double-click on the item in the Projects window.

Procedure and Full-Module Views

Generally, a code module contains more than one procedure. The IDE offers the choice between viewing one procedure at a time (called procedure view ) or all procedures at one time (called full-module view), with a horizontal line separating the procedures. Each view has its advantages and disadvantages, and you will probably want to use both views at different times. Unfortunately, Microsoft has not supplied a menu choice for selecting the view. (I’ve complained about this in my other books as well, but Microsoft does not seem to be listening to me. Strange.) To change views, we need to click on the small buttons in the lower-left corner of the Code window. (The default view can be set using the Editor tab of the Options dialog box.)

Incidentally, the default font for the module window is Courier, which has a rather thin looking appearance and may be somewhat difficult to read. You may want to change the font to FixedSys (on the Editor Format tab of the Options dialog, under the Tools menu), which is much more readable.

The Object and Procedure List Boxes

At the top of the Code ...