When you enter data into a column in a form, processing begins at the top of the display value column of the associated code table.
If the data matches a display value, the corresponding data value is put in the internal buffer. For each display value, the first data value is used. Using the sample code table, if you enter Massachusetts, ma, or Mass, the data value is MA.
You can specify that only the values in the code table are acceptable:
For a column using the Edit edit style, select the Validate check box.
For the DropDownListBox and DropDownDataWindow edit styles, clear the Allow Editing check box: you cannot type a value.
Although users cannot type a value when you clear the Allow Editing check box, they can search for a row in the drop-down list or DataWindow by typing in the initial character for the row display value. The search is case sensitive. For the DropDownDataWindow edit style, the initial character for a search cannot be an asterisk or a question mark. This restriction does not apply to the DropDownListBox edit style.