Microsoft Office Tutorials and References
In Depth Information
Chapter 3: Creating Smarter Forms
Chapter 3: Creating Smarter Forms
In This Chapter
Making drop-down menus and list boxes
Displaying Yes/No fields as option or toggle buttons
Grouping radio buttons
Adding cool command buttons
Making a Find box for searching records
Adding headers and footers to your forms
Displaying form data on multiple tabs
Validating what people type
Creating a main-menu form for your database
Setting a form to run automatically when you open the database
In Chapters 1 and 2 of this minibook, we explain how to make forms and
reports, as well as how to add labels, text boxes, check boxes, lines, and
rectangles to them. You can go a long way with just those controls, but
you’ll miss a lot of the power of Access. Combo boxes and list boxes enable
you (or your users) to choose values from lists instead of typing them, and
these lists can come from related tables in the database. If a field contains
a small number of possible values, you may want to present them as radio
buttons. Best of all, forms can display records from more than one table
through subforms. This chapter explains all this — and more.
This chapter doesn’t apply to reports. Because you can’t use reports for
entering and editing data, the interactive features discussed in this chapter
just don’t work for reports (at least, not unless you have much fancier paper
than we do!).
Creating and Configuring Combo and List Boxes
Combo boxes and list boxes are two controls that work like the drop-down
menus that you see in Windows programs. Each box displays a list of values
from which you can choose one value. The difference between the controls
is how many values they display. A combo box shows only the currently
selected value; you click the down arrow on its right side to get the list to
drop down so you can select a different value. A list box shows all the
possible values (or as many as fit in the control, with a scroll bar you can use
Search JabSto ::




Custom Search