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 Horizontal 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: Vertical Scroll Bar option.