Set Default Values Dialog Box
Use the Set Default Values dialog box to specify the default prompts you want to appear with your parameter field.
This dialog box appears when you click Set Default Values in the Create Parameter Field dialog box or the Edit Parameter Fields dialog box.
Select From Database
| Browse table | Use this list to pick the table you want to browse for fields/values to use for changing the Default Values for your parameter field. |
| Browse field | Use this list to pick the field you want to browse for values to use for changing the Default Values for your parameter field. |
Select or Enter Value
Use the "Select or enter value" box to enter values in the Default Values list. You can type new values in the "Select or enter value" box and then press the add button (>), or you can select a value from the "Select or enter value" list (beneath the "Select or enter value" box) and then press the add button (>).
| Add (>) | Use the add button to move values from the "Select or enter value" box to the Default Values list. |
| Add all (>>) | Use the add all button to move all values in the "Select or enter value" list to the Default Values list. |
| Delete (<) | Use the delete button to remove a value from the Default Values list. |
| Delete all (<<) | Use the delete all button to remove all values from the Default Values list. |
| Default Values | Use this list to create a list of default values for the parameter field you are creating. The items you choose for the Default Values list may represent a subset of the items you chose in the Browse Table list and the Browse Field list. |
| Order arrow buttons | Use the Order arrow buttons to move a value up or down in the Default Values list. |
| Import | Click this button to import a text file containing a pick list of parameter values. |
| Export | Click this button to export the pick list of parameter values to a text file. |
| Set Description | Use this option to add a description to any value in the Default Values list. Clicking this button opens the Define Description dialog box. |
Options
| Length limit | By selecting the Length limit check box for a String value, you can determine the minimum or maximum length for a parameter value entered on the Enter Parameter Values dialog box. This option is not selected by default. |
| Min Length | Use the Min Length box to limit the minimum number of characters that can appear in your String value parameter field. |
| Max Length | Use the Max Length box to limit the maximum number of characters that can appear in your String value parameter field. |
| Edit mask | For a string parameter field, you can choose to enter an Edit Mask in the Edit Mask box, rather than specifying a range. The Edit Mask can be any of a set of masking characters used to restrict the values you can enter as parameter values (the edit mask also limits the values you can enter as default prompting values).
Note When you enter an Edit Mask, the length options become inactive. |
| Display | Use the Display list to select how you'd like the Default Values in the Enter Parameter Values dialog box to appear. If you select Value and description, the default values are displayed as the values and their corresponding Descriptions. If you select Description, only the descriptions of the values are displayed. |
| Order | In the Order list, you can specify whether you want the default values sorted. The sorting order can be alphabetically ascending, alphabetically descending, numerically ascending, numerically descending, DateTime ascending, or DateTime descending. |
| Order based on | In the Order based on list, you can specify whether to sort default values based on value or description.
Note If you apply numerical sorting to an alphabetic value or description, the default values will not be sorted. |