Access 2016 Intermediate

Access 2016

Lesson 8 – Using Controls and Layouts

Category

Description

Format

Specifies the appearance of objects, such as the font characteristics, position, and size of a text box, or whether or not scroll bars appear on a form. Determines the characteristics of the data displayed, such as the data’s control source, default value, or whether or not it can be edited. Change the data source for an individual control or for the entire form. Specifies a procedure that Access executes when an event occurs. Some examples of events include clicking a control (OnClick), deleting data (OnDelete), and opening the form (OnOpen). The procedure can be an expression, a macro, or a Visual Basic for Access routine. Shows additional control features, such as the name of the control or whether or not a control is in the tab order.

Data

Event

Other

All

Displays all the properties of the object in one list.

NOTE Press [F4] to on the keyboard to open the Property Sheet .



Procedures

1. Open the desired form or report in Design view. 2. Select the desired object. 3. Press [F4] to view the Property Sheet . 4. Select the desired tab on the Property Sheet .



Step-by-Step

View the properties of an object.

Open the Customer Sales 5 form in Design view.

Page 151

OFFICEPRO, Inc.