When data is retrieved into a report or form column with a code table, processing begins at the top of the data value column. If the data matches a data value, the corresponding display value displays. If there is no match, the actual value displays.
Consider the example in Table 8-10.
Display values |
Data values |
|---|---|
Massachusetts |
MA |
Massachusetts |
ma |
ma |
MA |
Mass |
MA |
Rhode Island |
RI |
RI |
RI |
If the data is MA or ma, the corresponding display value (Massachusetts) displays. If the data is Ma, there is no match, so Ma displays.
If the code table is in a DropDownListBox edit style, and if the column has a code table that contains duplicate display values, then each value displays only once. Therefore, if this code table is defined for a column in a form that has a DropDownListBox edit style, Massachusetts and Rhode Island display in the ListBox portion of the DropDownListBox.
