Show All

Set the default control type for a field (MDB)

Note  The information in this topic applies only to a Microsoft Access database (.mdb).

You can set a default control type for Text, Number, and Yes/No fields. For Text and Number fields, the default control type can be a text box, combo box, or list box (forms only). For Yes/No fields, the default control type can be a check box, text box, or combo box. Once you have set a field's default control type, Microsoft Access uses that type of control to display the field's data in the datasheet for a table. Also, it automatically creates that type of control whenever you add that field to a form or report.

1. Open the table that contains the field in Design view.
2. Click in the Data Type column for a Text, Number, or Yes/No field.
3. Click the Lookup tab in the lower portion of the screen.
4. In the DisplayControl property box, click a control type in the list.