Microsoft Office® Access 2007 Inside Out

Setting Control Properties

Access 2007 gives you many properties for each control to allow you to customize the way your form works. These properties affect formatting, the presence or absence of scroll bars, the enabling or locking of records, the tab order, and more.

Formatting Properties

In the property sheet for each text box, combo box, and list box are three properties that you can set to determine how Access displays the data in the form. These properties are Format, Decimal Places, and Input Mask, as shown in Figure 12-43. (The Input Mask property is listed farther down the list on the All tab of the property sheet and isn’t shown in Figure 12-43.)

Figure 12-43. You can select a format from the list of format settings for the BirthDate control, ...