Microsoft Office Tutorials and References
In Depth Information
Designing Cool Looks for Yes/No Fields
Access draws a box for the option group and then runs the Option
Group Wizard. Don’t worry if the rectangle for the option group is the
wrong size; you can resize it later.
4. When the wizard prompts you for a list of the labels for the individual
option buttons, type the labels, one per line, and then click Next.
Don’t press Enter after typing a value; if you do, the wizard thinks that
you’re clicking Next and takes you to the next window. Instead, press
Tab or the down arrow to move to the next row in the datasheet. (If
you accidentally press Enter, click the Back button to get back to this
5. In the next window, choose the default value for the field or choose
the No I Don’t Want a Default option, and then click Next.
This answer determines whether one of the choices that you just typed
starts out as selected when you create a new record in the table.
When you click Next, you see a list of the labels that you typed in Step 4.
6. In the Values column on the right side, type the number to store for
each value, as shown in Figure 3-6, and then click Next.
Each label must have a different value, and all the values have to be
whole numbers. Access will fill in autoincrementing default values, but
you can change them if you want to.
a value for
button in the
7. Choose to save the value for later use or to store it in a field (and
specify the field), and click Next.
If you’re creating a form for editing a table, choose the Store the Value
in This Field option. If the form is unbound (not connected to a record
source), and the options are for use as input to a query, macro, or VBA
module, choose the Save the Value for Later Use option. (See Book VI,
Chapter 1 for details on running macros from a form, possibly using
inputs from the form.)