Microsoft Office Tutorials and References
In Depth Information
Creating Check Boxes for Yes/No Fields
Creating Check Boxes for Yes/No Fields
When you drag a Yes/No field from the field list to a form or report in Design
view, Access assumes that you want to display the field as a check box: A
Yes value appears as a checked box, and a No value appears as a blank box.
You can’t change the size of a check box. Dragging its edges expands the box
around it, but the check box just sits there.
Another way to create a check box is to click the Check Box button in the
Controls group on the Design tab of the Ribbon and then click the form
where you want a check box to appear. If you use this method, you need to
set the check box’s Control Source property on the Data tab of the
property sheet to the name of the Yes/No field.
Alternatively, you can display different information depending on whether
the value of the Yes/No field is Yes or No. For tax-exempt companies, for
example, your order form can display a Tax Exempt ID box that appears only
if the Tax Exempt field is set to Yes. See Chapter 3 of this minibook
for information on displaying information that depends on other fields in
this way.
Adding Lines, Boxes, and Backgrounds
Some forms and reports have several sections, and they’re easier to use if
you separate the sections with lines or boxes. An order form might have one
section with information about the customer, another section showing what
items were ordered, and a third section with payment information.
To draw a line, click the Line button in the Controls group on the Design tab
of the Ribbon, and draw the line on the form with your mouse.
Drawing a box works the same way. Click the Rectangle button in the
Controls group on the Design tab of the Ribbon and draw the box, starting at
one corner and dragging the mouse to the opposite corner.
Book IV
Chapter 2
You can set the colors and thickness of a line or box by clicking the Shape
Outline button in the Control Formatting group on the Format tab of the
Ribbon and choosing a color, line thickness, or line type.
You can specify a picture to display in the background of the form or report.
Picture backgrounds seem like demented ideas to us; we hate forms and
reports that have clouds or sunsets in the background because they make
the forms look busier and more confusing. But if you want to jazz up your
form or report, click the Background Image button in the Background group
on the Format tab of the Ribbon; then choose an image from their gallery or
click Browse to choose a picture of your own. Select the image and click OK
to set the Picture property on the Format tab of the property sheet to the
filename of a picture.
Search JabSto ::




Custom Search