Field Properties dialog box

Sets properties for the field selected in the Selected Fields list of the Fields Property Builder.

Dialog Box Options

Heading

Enter a heading for the field column. If you leave this blank, the heading is the field name. The maximum width of the heading is 127 characters.

Template

Specifies one or more symbols that format data entered into this field. For example, you can convert to uppercase. Click to choose symbols with the Choose Template dialog box.

When

Enter a condition that allows the field to be edited. The condition should be an expression that, when it evaluates to True, allows editing of the field. (This often depends on the value of another field.)

Width

Enter the display width of the selected field. If you leave this blank, the full width of the field appears.

Read-Only

Creates a field that cannot be edited.

Color

Specifies a color for the selected field on the Fields page of the Table Records Window Properties dialog box. Click to choose a color in the Color Property Builder.

Valid Expression

Enter an expression that determines whether an entry in the field is valid.

Valid Error Message

Enter an error message to display if the data entered in the field is invalid because the Valid Expression evaluated to False.

Required

Turn on the Required option to prevent users from leaving the field until valid data is entered.

Lower Limit

Enter an expression that represents the lowest of a valid range of values.

Upper Limit

Enter an expression that represents the highest of a valid range of values.

Required

Turn on the Required option to prevent users from leaving the field until valid data is entered. To choose a range of values that are valid, use the Lower Limit and Upper Limit boxes.

How to get there: From the Properties button in the Fields Property Builder.