For a list box or record picker control whose type is set to Simple Cards or Custom Cards, you can use the Columns property page to specify the data fields that appear on the cards.
Columns Property Page |
Use the Columns property page to customize the columns that appear in the following controls on the data entry form:
Dropdown list (when the control type is set to Multiple Columns)
Dropdown record picker
Record picker
List box (when the control type is set to Multiple Columns, Simple Cards, or Custom Cards)
|
|
For a list box or record picker control whose type is set to Simple Cards or Custom Cards, you can use the Columns property page to specify the data fields that appear on the cards. |
Depending on the control type, the following options may be available:
Automatically create columns for each database field: Specifies that the control automatically creates all the columns for the fields in the result set. When you select this option, you cannot delete or add columns in the Columns pane, and you cannot edit the Field Name property for any columns.
Resize all columns to fit width of control: Specifies that columns widths are expanded or contracted to fit the size of the control. When you select this option, column data might be clipped 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 that 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, from top to bottom, is the order in which they appear in the control, from left to right or top to bottom.
You can use the columns toolbar, which is located at the bottom of the Columns pane, to remove columns from the control, to modify the order in which the columns are displayed in the control, to add new columns to the control, and to re-add default columns to the control if they were removed.
The following options are available:
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 that are included in the record set. If you previously deleted a column that was part of the default record set, that column is re-added to the list when you refresh the list. This option does not delete any new columns that you may have added.
Column Properties
The Columns Properties pane lists the properties for the column that is selected in the Columns pane.
|
|
Some properties include a selection dialog, which you can access by clicking |
Appearance
Foreground Color: Specifies the font color.
Background Color: Specifies the background color for the selected column.
Bold: Specifies whether the font is formatted as bold.
Italic: Specifies whether the font is formatted as italic.
Size Adjustment: Specifies a size adjustment to the default column font size. For instance, if you enter the value 2, the font size is increased by two font points. If you enter the value -2, the font size is decreased by two font points.
Column
Display Name: Specifies the name for the column as it appears in the control.
Field Name: Specifies the field from the result set that you want to use to populate the column. Available only when Automatically create columns for each database field is not selected.
Layout
Visible: Specifies whether the column is visible in the control.
Horizontal Alignment: Specifies the horizontal alignment (left, center, or right) of the data within the column.
Vertical Alignment: Specifies the vertical alignment (top, center, or bottom) of the data within the column.
Width: Specifies the width of the column in pixels.
Wrap Text: Specifies whether the column uses text wrapping.
Horizontal Scrolling: Specifies whether the column uses horizontal scrolling. When Fixed on Left or Fixed on Right is selected, the selected column is locked 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 not selected.
This property page is available for the following controls:
to the right of the selected property. You can use this selection dialog to specify a property setting. Alternatively, in some cases, you can click just to the right of the property and then enter your selection.