Microsoft Office Tutorials and References
In Depth Information
But suppose another piece of information is health plan — which of the three company health
plans is the employee enrolled in? Again you have mutually exclusive choices, so why not use
OptionButtons again? But you cannot be guaranteed that your company will always offer only
three health plans. Suppose they expand the offering to eight plans — modifying the form to
include eight OptionButton controls would be a hassle, not to mention that the form’s visual
appearance would suffer. Better in cases like this to use a ComboBox, which offers an easily
expandable list of mutually exclusive choices.
Creating a Custom Field
Once you have decided how to implement your custom field, there are two ways to go about it.
The end result is the same, but one technique gives you more flexibility in selecting the control
type that will be used.
Using the Field Chooser to Define a New Field
The Field Chooser has a New button that you click to define a new field. It brings up the New
Field dialog box, shown in Figure 27.1. Enter information about the field as follows:
n Name: The name of the field.
n Type: The data type of the field (text, number, date, yes/no, and so on).
n Format: Select the display format for the field.
Defining a custom field for a form.