ddlb.property

Description

Properties that control the appearance and behavior of a column with the DropDownListBox edit style.

Applies to

Column controls

Syntax

Describe and Modify argument:

"columnname.ddlb.property { = value }"

Parameter

Description

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.

Property for ddlb

Value

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.

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.

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.

Limit

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

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.

Required

Whether the column is required.

Values are:

  • Yes – Required.

  • No – (Default) Not required.

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.

Sorted

Whether the list in the DropDownListBox is sorted.

Values are:

  • Yes – The list is sorted.

  • No – The list is not sorted.

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.

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.

Usage


In the painter

Select the control and set the value in the Properties view, Edit tab, when Style Type is DropDownListBox.

Examples

Example 1

ls_data = dw1.Describe("emp_status.ddlb.AllowEdit")

dw1.Modify("emp_status.ddlb.Case='Any'")

dw1.Modify("emp_status.ddlb.Limit=30")