Number of Characters Dialog |
The Number of Characters dialog allows you to specify how many characters can appear in the selected data source.
You can access this dialog in one of the following ways:
Click next to Number of Characters on the Transforms tab of the Data Sources property page (for template objects).
Click next to Number of Characters on the Data Entry property page (for data entry controls).
Click next to Number of Characters on the More Query Prompt Options dialog (for query prompts).
The following options are available:
Minimum Number of Characters
Require minimum number of characters: When enabled, activates the options for specifying the minimum number of characters allowed in the selected data source.
Minimum Number of Characters: Defines the number of characters required in the selected data source.
Pad On: If the data source does not contain the minimum number of characters, specifies whether extra characters will be inserted on the left or right side of the existing data.
Pad Character: Specifies the character to append to the existing data if the minimum number of characters requirement is not met.
Warn when minimum not met:
Maximum Number of Characters
Limit maximum number of characters: When enabled, activates the options for specifying the maximum number of characters allowed in the selected data source.
Maximum Number of Characters: Defines the maximum number of characters allowed in the selected data source.
Warn when maximum exceeded: