Inserts a new column into the list.
Columns Property Page |
The Columns property page allows you to customize the columns that appear in a Record Picker or Dropdown Record Picker control.
Automatically create columns for each database field: When enabled, the control automatically creates all the columns for the fields in the result set. You will not be able to delete or add columns in the Columns pane, and you will not be able to edit the Field Name property for any columns.
Resize all columns to fit width of record picker: Expands or contracts column widths to fit the size of the control. May result in clipping of column data if the control width is narrow or if the record set has many columns.
Columns
By default, the Columns pane lists the columns, by field name, that are part of the record set and which are displayed in the control. You can select a column in the Columns pane to edit its properties in the Column Properties pane.
The order in which the columns appear in the Columns pane, top to bottom, is the order in which they will appear in the record picker, left to right.
The columns toolbar is located at the bottom of the Columns pane. It allows you remove columns from being displayed in the control, modify the order in which the columns are displayed in control, add new columns to the control, and add default columns back into the control if they had previously been removed.
Inserts a new column into the list.
Removes the selected column from the list.
Moves the selected column up one position in the list.
Moves the selected column down one position in the list.
Refreshes the Columns list to include all fields included in the record set. If you had previously deleted a column that was part of the default record set, refreshing the list will add that column back to the list. Does not delete any new columns that you may have added.
Column Properties
The Columns Properties pane lists the properties for the column selected in the Columns pane.
|
|
Some properties include a selection dialog, accessed by clicking |
Appearance
Background Color: Specifies the background color for the selected column.
Bold: Specifies whether the font is bolded.
Foreground Color: Specifies the font color.
Italic: Specifies whether the font is italicized.
Size Adjustment: Specifies a size adjustment to the default column font size. For instance, typing the value 2 here would increase the font size by two font points; typing the value -2 would decrease the font size by two font points.
Column
Display Name: Specifies the name for the column as it appears in the control.
Field Name: Specifies the database field that you want to populate the column. Available only when Automatically create columns for each database field is disabled.
Layout
Horizontal Alignment: Specifies the horizontal alignment (left, center, or right) of the data within the column.
Horizontal Scrolling: When Fixed on Left or Fixed on Right is selected, locks the selected column to the indicated side of the control so that the column is not affected by horizontal scrolling. Available only when Resize all columns to fit width of record picker is disabled.
Vertical Alignment: Specifies the vertical alignment (top, center, or bottom) of the data within the column.
Visible: Specifies whether the column is visible in the control.
Width: Specifies the width of the column in pixels.
Wrap Text: Specifies whether the column allows text wrapping.
This property page is available for the following controls:
to the right of the selected property, that you can use to specify a property setting. Alternatively, you may be able to click just to the right of the property and type your selection.