1.4 Text Field

To define a text field, choose the text option at the Field Type field. A text field can contain alphabets of the English language or a combination of alphabets and numeric values.

You can specify validation rules for a text field. The validation types applicable to a text field include:

• Length
• Mask
• LOV
• None

You can indicate your preference at the validation type field of this screen. Choose None to indicate that no validation should be performed on entries made to this field.

Validation Type - Length

For a text field you can indicate that a valid entry to the field should be of a certain length. You have the option to indicate,

• A fixed length
• The maximum and minimum length for the field

Depending on the option that you select, indicate the fixed field length or indicate the maximum and minimum length of entries made to the field.

Validation Type - Mask

To indicate a field as a masked field, choose Mask as the field type. This option allows you to define a broad field structure to which all entries to the field should conform.

The mask structure can consist solely of a or n or a combination of these. An a indicates an alphabet of the English language and n a numeric value.

All entries made to the fieldis validated with the format that you specify for the mask.

This topic contains following sub-topics:

• Validation Type - LOV (List of Values)
  
• Derivation