Use the Data Conversion section to globally set field properties, including default values, display formats, and string conversion.

Default Value

The default value, if any, with which to populate the record when it is initially displayed and added to the database.  Default values may be any text string.

Note: If you initialize a field for which the Display Foreign Key As option is set, the initialization value “supersedes” the Display Foreign Key As setting and the database will not be queried to display the string value corresponding to the initialization value unless the Display Style is a list box, dropdown list, or radio button list.  The list box Display Styles require the database to be queried to determine all of the foreign key values in order to build the list; this is not true for Display Styles that display only a single value – the initialization value.

Storage Format

Optional.  Specifies the field’s storage format, typically for numbers and dates.

See Storage Format Options for details.

Case Conversion

Optional.  Specifies a special processing function to be performed on data entered into the field when new records are created or existing records are updated.

Permitted values

Specifies a list of possible legal values for the field.

For more information, see:

Permitted Value List

Adding Not-Null Field Constraints