DisplayControl Property

Applies To

Query Fields, Table Fields.

Description

You can use the DisplayControl property in table Design view to specify the default control you want to use for displaying a field.

Setting

The DisplayControl property contains a drop-down list of the available controls for the selected field. For fields with a Text or Number data type, the DisplayControl property can be set to Text Box, List Box, or Combo Box. For fields with a Yes/No data type, the DisplayControl property can be set to Check Box, Text Box, or Combo Box.

You can set this property in the table’s property sheet in table Design view by clicking the Lookup tab under Field Properties.

Microsoft Access sets the DisplayControl property automatically when you select Lookup Wizard as the data type for a field in table Design view.

Remarks

When you select a control for the DisplayControl property, any additional properties needed to configure the control are also displayed on the Lookup tab.

Tip Let Microsoft Access set the DisplayControl property and any related properties for you by using the Lookup Wizard.

Setting the DisplayControl property and any related control type properties will affect the field display in both Datasheet view and Form view. The field is displayed using the control and control property settings set in table Design view. If a field had its DisplayControl property set in table design view and you drag it from the field list in form Design view, Microsoft Access copies the appropriate properties to the control’s property sheet.