Character Filter Dialog |
Use the Character Filter dialog to force the contents of the selected data source or data entry control to conform to certain rules. You can use the options on the Character Filter dialog with any of the different data source types; however, typically they are used when input is read from a database or when data is entered into the data entry form at print time.
To access this dialog, use one of the following methods:
For template objects, click next to Character Filter.
For data entry controls, click next to Character Filter on the Data Entry property page.
For query prompts, click next to Character Filter on the More Query Prompt Options dialog.
The available options for configuring a character filter include the following:
Allowable Characters: Specifies the type of characters that are accepted as input into the data field. When characters other than those that are specified in Allowable Characters are read from a database or entered into the data entry form, the unwanted characters are removed from the data. For example, if you specify that only numbers are allowed, any letters or spaces are removed. In this case, if the Warn When Data Validation Fails option is selected, you receive a message if any non-numeric characters are encountered to indicate that they were removed.
Characters: Specifies the characters that are accepted, based on the option that is selected for Allowable Characters. When the Allowable Characters option is set to Custom, you can use the Characters field to specify the characters that are allowed. This option is available for any Allowable Characters selection except Set by Input Mask or Set by Regular Expression.
Options
Convert to Uppercase: Changes alphabetical data to capital letters.
Convert to Lowercase: Changes alphabetical data to lowercase letters.
Warn When Data Validation Fails: Specifies that a message is displayed when the data contains unwanted characters. You can then remove the unwanted characters and then continue or cancel the print job.