Record Picker Property Page |
The Record Picker property page enables you to define how the control is displayed to users on the data entry form at print-time. While a full Select Records dialog is supported by the control, you may choose to have different options enabled or disabled.
|
Options that have been disabled on the property page will also be disabled in the control's print-time context menu. |
Properties
Search Control: The Search Control input box is located at the top of the control. It enables users to filter the displayed record set by entering a key word (or partial spelling of a key work) into a text box.
Always Show: When selected, the Search Control is always available on the control with no option for users to hide it.
Show by Default: When selected, the Search Control is available on the control by default, but users can hide it at print-time from the control's context menu.
Hide by Default: When selected, the Search Control is hidden by default, but users can show it at print-time from the control's context menu.
Always Hide: When selected, the Search Control is always hidden, with no option for users to show it.
Filter Row: The filter row appears just above the rows returned in the record set. The filter row provides an input box for each column in the result set, into which the user can type values that are then used to filter the result set.
Always Show: When selected, the Filter Row is always available on the control with no option for users to hide it.
Show by Default: When selected, the Filter Row is available on the control by default, but users can hide it at print-time from the control's context menu.
Hide by Default: When selected, the Filter Row is hidden by default, but users can show it at print-time from the control's context menu.
Always Hide: When selected, the Filter Row is always hidden, with no option for users to show it.
Show column headers: When checked, column headers are visible on the control. When unchecked, column headers are not displayed.
Lock column order: When checked, users are unable to re-arrange the column order of the returned record set. When unchecked, users can drag and drop columns to change column order. Available when Show column headers is checked.
Lock column widths: When checked, users are unable to re-size the column widths of the returned record set. Available when Show column headers is checked.
Sort By: Specifies the default column you want the record set sorted by at print-time. Check Locked to disable the user's ability to change the sort option specified.
Group By: Condenses the length of the result set by grouping the records by the field (column) of your choosing. At print-time, the user can expand groups to access the records contained within them. Check Locked to disable the user's ability to change the option specified.
Selection Mode: Specifies how users select records from the record set.
Single: Users can select only one record from the returned record set. Clicking on a record deselects any previous selection.
Extended: Users can select any number of records from the returned record set. They can select non-consecutive records by holding the Ctrl key down while clicking on the records that you want. They can select a set of consecutive records by clicking on their first selection, and then holding down the Shift and clicking the last record in the consecutive set. Individual records can be de-selected by holding the Ctrl key down while clicking on the records that you don't want.
Toggle: Users can select any number of records from the returned record set. They can simply select records by clicking on each record that they want. Clicking again on an already selected record will de-select it.
Selector Column: The selector column appears just to the left of the first column of the record set.
None: No selector column is displayed.
Checkbox: When selected, a checkbox enables the user to check each record they want to print.
Quantity: When selected, a quantity column enables users to select how many copies of each record they want to print.
Row Highlighting: Specifies the row highlighting displayed on the form.
None: When selected, there is no row highlighting.
Even Rows: When selected, only the even rows are highlighted.
Odd Rows: When selected, only the odd rows are highlighted.
Both: When selected, the even and odd rows are both highlighted, but in contrasting shades.
Record numbers: When enabled, the records returned in the record set are numbered on the left side of the control.
Record navigator: When enabled, a record navigator is available at the bottom of the control to assist users in browsing the record set.
Record selection input box: When enabled, a record selection input box is available at the bottom of the control so that users can specify the record numbers to print. A series of record numbers can be separated using commas: 1,3,7. A range of records can be specified using hyphens: 1-3. A series and a range of records can be specified using a combination of the two: 1-3,7,8. Furthermore, users by specify the quantity to print of each selected record using parentheses: 1-3,7,8,9(14),12-40,41-43(14). When a quantity is provided using parentheses, the value provided will override the Quantity setting (if enabled).
This property page is available for the following controls: