Microsoft® Access® 2010 Inside Out

Setting Control Properties for Client Forms

Access 2010 gives you many properties for each control to allow you to customize the way your client 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 14-21. (The Input Mask property is listed farther down the list on the All tab of the property sheet and isn’t shown in Figure 14-21.)

Figure 14-21. You can select a format from the list of format settings ...