About property sheets

In Microsoft Access, you use properties to determine the characteristics of tables, queries (query: A question about the data stored in your tables, or a request to perform an action on the data. A query can bring together data from multiple tables to serve as the source of data for a form or report.), fields, forms, reports, and data access pages (data access page: A Web page, published from Access, that has a connection to a database. In a data access page, you can view, add to, edit, and manipulate the data stored in the database. A page can also include data from other sources, such as Excel.). Every section and control (control: A graphical user interface object, such as a text box, check box, scroll bar, or command button, that lets users control the program. You use controls to display data or choices, perform an action, or make the user interface easier to read.) on a form, report, or data access page has properties as well. Control properties determine the structure, appearance, and behavior of a control, as well as the characteristics of the text or data it contains.

You set properties by using the property sheet. For example, the following illustration shows the property sheet for a TotalSales control on a report. The Format property for this control is set to Currency.

Property sheet for the TotalSales text box

Callout 1 The title bar shows the type and name of the selected object.

Callout 2 Each tab displays properties of a specific category.

Callout 3 The values displayed in the TotalSales control will be formatted as currency.

Applies to:
Access 2003