Record Picker Property Page |
Use the Record Picker property page to specify how the control is displayed to users on the data entry form at print time.
Type
Multiple Columns: Specifies that database records are displayed in multiple columns. When you select this type, the control supports a fully featured Select Records dialog, but you can choose which options to use.
Simple Cards: Specifies that the control appears as multiple cards on the form, where each card represents a single database record, and each card displays one or more fields for the database record.
Custom Cards: Specifies the same functionality as the simple cards type but with support for additional layout customizations.
The properties that are available to configure vary depending on the record picker type that you select.
Size
Width: Specifies the horizontal dimension of the control in the specified unit of measurement.
Height: Specifies the vertical dimension of the control in the specified unit of measurement.
Features
Search Control: Specifies that the search control input box is displayed. This feature makes it possible for users to filter the displayed record set by entering a keyword (or partial spelling of a keyword) into the input box.
Always Show: Specifies that the search control is always available on the control, with no option for users to hide it.
Show by Default: Specifies that the search control is available on the control by default, but users can hide it at print time by using the control's context menu.
Hide by Default: Specifies that the search control is hidden by default, but users can show it at print time by using the control's context menu.
Always Hide: Specifies that the search control is always hidden, with no option for users to show it.
Remember search: Specifies that the most recently used search criterion is used for the next print job. Available when Search Control is not set to Always Hide.
Filter Row: Specifies whether the filter row is displayed. The filter row provides an input box for each column in the record set into which the user can enter values that are then used to filter the record set.
Always Show: Specifies that the filter row is always displayed, with no option for users to hide it.
Show by Default: Specifies that the filter row is displayed by default, but users can hide it at print time by using the control's context menu.
Hide by Default: Specifies that the filter row is hidden by default, but users can show it at print time by using the control's context menu.
Always Hide: Specifies that the filter row is always hidden, with no option for users to show it.
Remember filter: Specifies that the most recently used filter is used for the next print job. Available when Filter Row is not set to Always Hide.
Show column headers: Specifies that column headers are displayed on the control. When this option is not selected, column headers are not displayed.
Lock column order: Specifies that users cannot rearrange the column order of the returned record set. When this option is not selected, users can drag columns to change column order. Available when Show column headers is selected.
Lock column widths: Specifies that users cannot resize the column widths of the returned record set. Available when Show column headers is selected.
Group By: Specifies a column heading to group the records by. At print time, the user can expand groups to access the records that they contain. Click to select the Locked check box to prevent the setting from being changed.
Sort By: Specifies a column heading to sort the records by at print time. Click to select the Locked check box to prevent the setting from being changed.
Selection Mode: Specifies how users select records from the record set.
Single: Specifies that users can select only one record from the returned record set. Users click a record to undo any previous selection.
Extended: Specifies that users can select any number of records from the returned record set. To select non-consecutive records, they press Ctrl and then click the records that they want. To select a set of consecutive records, they click the first record, and then press Shift and click the last record in the consecutive set. To undo the selection for individual records, they press Ctrl and click the records that they do not want.
Toggle: Specifies that users can select any number of records from the returned record set. To select records, they click each record that they want. To undo the selection, they click the record again.
Selector Column: Specifies the configuration of the selector column, which appears just to the left of the first column of the record set.
None: Specifies that no selector column is displayed.
Checkbox: Specifies that a check box is available for users to mark each record that they want to print.
Quantity: Specifies that a quantity column is available for users to select how many copies of each record they want to print.
Row Highlighting: Specifies the row highlighting that is displayed on the control.
None: Specifies that there is no row highlighting.
Even Rows: Specifies that only the even rows are highlighted.
Odd Rows: Specifies that only the odd rows are highlighted.
Both: Specifies that the even and odd rows are both highlighted, but in contrasting shades.
Record numbers: Specifies that record numbers are displayed on the left side of the control.
Record navigator: Specifies that a record navigator is displayed at the bottom of the control so that users can browse the record set.
Record selection input box: Specifies that a record selection input box is available at the bottom of the control so that users can specify the record numbers to print, as follows:
A series of record numbers can be specified by using commas (for example: 1,3,7).
A range of records can be specified by using hyphens (for example: 1-3).
A series and a range of records can be specified by using a combination of commas and hyphens (for example: 1-3,7,8).
The number of copies to print for each selected record can be specified by using parentheses (for example: 1-3,7,8,9(14),12-40,41-43(14)). When a quantity is specified by using parentheses, the value that is specified overrides any specified Quantity setting.
Size
Width: Specifies the horizontal dimension of the control in the specified unit of measurement.
Height: Specifies the vertical dimension of the control in the specified unit of measurement.
Features
Search Control: Specifies that the search control input box is displayed. This feature makes it possible for users to filter the displayed record set by entering a keyword (or partial spelling of a keyword) into the input box.
Always Show: Specifies that the search control is always available on the control, with no option for users to hide it.
Show by Default: Specifies that the search control is available on the control by default, but users can hide it at print time by using the control's context menu.
Hide by Default: Specifies that the search control is hidden by default, but users can show it at print time by using the control's context menu.
Always Hide: Specifies that the search control is always hidden, with no option for users to show it.
Remember search: Specifies that the most recently used search criterion is used for the next print job. Available when Search Control is not set to Always Hide.
Allow changing field visibility: Specifies that the sorting and filtering settings can be changed. When this option is not selected, the current sorting and filtering settings are locked.
Allow sorting: Specifies that the fields can be sorted. Available when Allow changing field visibility is selected.
Allow filtering: Specifies that the fields can be filtered. Available when Allow changing field visibility is selected.
Auto fit cards to width: Specifies that the cards are automatically sized to fit the data entry form.
Cards Across: Specifies the number of cards that appear in a row on the form. Available when Auto fit cards to width is selected.
Caption Format: Specifies the database field values that are the source of the text that appears in the header panel of the card. Click to display a list of available values, and then click the values that you want to use.
Allow Multiple Selection: Specifies that multiple records can be selected.
Record navigator: Specifies that a record navigator is displayed at the bottom of the control so that users can browse the record set.
Record selection input box: Specifies that a record selection input box is available at the bottom of the control so that users can specify the record numbers to print, as follows:
A series of record numbers can be specified by using commas (for example: 1,3,7).
A range of records can be specified by using hyphens (for example: 1-3).
A series and a range of records can be specified by using a combination of commas and hyphens (for example: 1-3,7,8).
The number of copies to print for each selected record can be specified by using parentheses (for example: 1-3,7,8,9(14),12-40,41-43(14)). When a quantity is specified by using parentheses, the value that is specified overrides any specified Quantity setting.
Size
Width: Specifies the horizontal dimension of the control in the specified unit of measurement.
Height: Specifies the vertical dimension of the control in the specified unit of measurement.
Features
View: Specifies how the cards are displayed on the form. Click to select the Lock check box to prevent the setting from being changed. The following views are available:
Single Record: Specifies that only one card appears at a time.
Single Column: Specifies that cards appear in one column.
Single Row: Specifies that cards appear in one row.
Multiple Columns: Specifies that cards appear in more than one column.
Multiple Rows: Specifies that cards appear in more than one row.
Carousel: Specifies that cards appear in a carousel format, where scrolling causes one card to move into the background and optionally become smaller and more transparent while the next card moves into the foreground.
View Settings: Opens the View Settings dialog, which you can use to configure the settings for the selected view type. Depending on the view type, one or more of the following options are available:
Stretch card to height: Specifies that the card is resized to fit the height of the form.
Stretch card to width: Specifies that the card is resized to fit the width of the form.
Maximum Columns: Specifies the maximum number of columns to be displayed.
Maximum Rows: Specifies the maximum number of rows to be displayed.
Pitch Angle: Specifies the angle at which cards in a carousel are pitched up or down. Valid values are from 0 to 180.
Radius: Specifies the size of the imaginary circle around which cards in a carousel rotate.
Roll Angle: Specifies the angle at which cards in a carousel are rolled around the center point of the form. Valid values are from 0 to 360.
Transparency: Specifies the transparency (as a percentage) of the background cards in a carousel. The range is from 0 (opaque) to 100 (completely transparent). For more information, refer to Transparency.
Fade: Specifies the degree (as a percentage) to which the cards in a carousel fade in or out when they are moving toward or away from the foreground.
Scale: Specifies the size (as a percentage) of the background cards in a carousel.
Card Count: Specifies the maximum number of cards in a carousel that are displayed at one time.
Search Control: Specifies that the search control input box is displayed. This feature makes it possible for users to filter the displayed record set by entering a keyword (or partial spelling of a keyword) into the input box.
Always Show: Specifies that the search control is always available on the control, with no option for users to hide it.
Show by Default: Specifies that the search control is available on the control by default, but users can hide it at print time by using the control's context menu.
Hide by Default: Specifies that the search control is hidden by default, but users can show it at print time by using the control's context menu.
Always Hide: Specifies that the search control is always hidden, with no option for users to show it.
Remember search: Specifies that the most recently used search criterion is used for the next print job. Available when Search Control is not set to Always Hide.
Show header panel: Specifies that the header panel is displayed on each card.
Allow sorting: Specifies that the records can be sorted.
Allow filtering: Specifies that the records can be filtered.
Caption Format: Specifies the database field values that are the source of the text that appears in the header of the card. Click to display a list of values from which you can select the values that you want to use.
Allow multiple selection: Specifies that multiple records can be selected.
Record navigator: Specifies that a record navigator is displayed at the bottom of the control so that users can browse the record set.
Allow customizing card template: Specifies that the icon appears on the data entry form at print time. The print operator can click this icon to open the LayoutView Customization dialog, which the print operator can use to customize the template card and view layout.
Customize Card Layout: Opens the LayoutView Customization dialog, which you can use to customize the template card and view layout.
Record selection input box: Specifies that a record selection input box is available at the bottom of the control so that users can specify the record numbers to print, as follows:
A series of record numbers can be specified by using commas (for example: 1,3,7).
A range of records can be specified by using hyphens (for example: 1-3).
A series and a range of records can be specified by using a combination of commas and hyphens (for example: 1-3,7,8).
The number of copies to print for each selected record can be specified by using parentheses (for example: 1-3,7,8,9(14),12-40,41-43(14)). When a quantity is specified by using parentheses, the value that is specified overrides any specified Quantity setting.
This property page is available for the following controls: