ddlb.property

columnname

The name of a column that has the DropDownListBox edit style.

property

A property for the DropDownListBox column. Properties and their settings are listed in the table below.

value

The value to be assigned to the property. For ddlb properties, value cannot be a DataWindow expression.

AllowEdit

Whether the user can type a value as well as choose from the DropDownListBox’s list. Values are:

• Yes — Typing is allowed.

• No — (Default) Typing is not allowed.

Painter: Allow Editing option.

AutoHScroll

Whether the DropDownListBox automatically scrolls horizontally when the user enters or deletes data. Values are:

• Yes — (Default) Scroll horizontally automatically.

• No — Do not scroll automatically.

Painter: Auto Horz Scroll option.

Case

The case of the text in the DropDownListBox. Values are:

• Any — Character of any case allowed.

• Upper — Characters converted to uppercase.

• Lower — Characters converted to lowercase.

Painter: Case option.

Limit

An integer from 0–32767 specifying the maximum number of characters that can be entered in the DropDownListBox. Zero means unlimited.

Painter: Limit option.

NilIsNull

Whether to set the data value of the DropDownListBox to NULL when the user leaves the edit box blank. Values are:

• Yes — Make the empty string NULL.

• No — Do not make the empty string NULL.

Painter: Empty string is NULL option.

Required

Whether the column is required. Values are:

• Yes — Required.

• No — (Default) Not required.

Painter: Required option.

ShowList

Whether the ListBox portion of the DropDownListBox displays when the column has focus. A down arrow does not display at the right end of the DropDownListBox when ddlb.ShowList is yes. Values are:

• Yes — Display the list whenever the column has focus.

• No — Do not display the list until the user selects the column.

Painter: Always Show List option.

Sorted

Whether the list in the DropDownListBox is sorted. Values are:

• Yes — The list is sorted.

• No — The list is not sorted.

Painter: Sorted option.

UseAsBorder

Whether a down arrow displays at the right end of the DropDownListBox. Values are:

• Yes — Display the arrow.

• No — Do not display the arrow.

Note that if ShowList is set to Yes, the column ignores the UseAsBorder property and the arrow never displays.

Painter: Always Show Arrow option.

VScrollBar

Whether a vertical scroll bar displays in the DropDownListBox for long lists. Values are:

• Yes — Display a vertical scroll bar.

• No — Do not display a vertical scroll bar.

Painter: V ScrollBar option.