Microsoft Office Tutorials and References
In Depth Information
Designing Cool Looks for Yes/No Fields
Property
Description
Whether entries in the combo box are limited to values on
the drop-down menu. Choose the No setting if you want to
be able to type other values in the control. (This property
isn’t used for list boxes, which are always limited to the
values listed.)
Limit to List
Designing Cool Looks for Yes/No Fields
Chapter 2 of this minibook describes how to create a check box for a Yes/
No field, which looks pretty spiffy. But you have other options for Yes/No
fields: option buttons (little round radio buttons) and toggle buttons (rectan-
gular buttons that appear to be pressed in when they’re selected). You can
display a Yes/No field in a text box, too, but the Yes value appears as –1
and the No value appears as 0, which may not be what you want. Figure 3-4
shows a check box, option button, and toggle button.
Figure 3-4:
Ways to
display a
Yes/No field.
One of the easiest ways to make a toggle or option button for a Yes/No field
is to create a check box for it and then change it into a toggle or option
button. Drag the field from the field list to the desired location on your form,
and Access makes a check box for the field. Right-click the field and choose
Change To Option Button or Change To Toggle Button from the
contextual menu that appears. Adjust the sizes and positions of the control and its
label, and you’re done!
Book IV
Chapter 3
Creating Option Groups
If a field is set to one of a small number of numeric, integer values — such
as 1 to 10 — you can display the values in a box, with an option button next
to each value. When you’re editing records by using the form, you click the
option for the value to which you want to set the field. Only one option can
be selected at a time; clicking one option deselects the other options.
Search JabSto ::




Custom Search