Please enable JavaScript to view this site.

ASQL Reference

Navigation: » No topics above this level «

Combo Box

Scroll Prev Top Next More

cformat switch:  l  (lower case el)

Similar to column format E except that instead of an edit control, a combobox control is used for editing the cell when the cell has the focus. The combo box choices must be defined with one of these Advanced Coldef Options: List, CellList, ListX and CellListX. There are three variations of comboboxes. In the default variation, the user can only select among the defined choices. If the E code is specified in addition to the  l  code, then the user will also be able to type in a text value that is not in the list. The third variation is the so-called "self-service" combo in which the list just contains "…" and when the user clicks on the dropdown button, it exits with exitcode 29 (as in INFLD).

Note: regardless of whether the E code is specified, combo box columns are treated like editable columns in that they must be represented in the answer array. In order to prevent individual cells or entire columns from being actually editable by the user, prefix the column data with a  |  (vertical bar). This may require expanding the column width, again both in the data array and answer array.