Tuesday, December 12

Edit Mask Options

Google+ Pinterest LinkedIn Tumblr +

You can enter any of the following mask characters, or any combination of them, in the Edit Mask field of the Set Default Values dialog box. Only use edit mask characters when basing a parameter on a string field. Using an edit mask disables die Length limit options.

«   “A” requires entry of an alphanumeric character in the parameter value.

•   “a” allows but does not require entry of an alphanumeric character in the parameter value. —

•   “0* requires entry of a digit [0 to 9] in the parameter value.

•   “9” allows but does not require a digit or a space in the parameter value.

•   “#” allows but does not require entry of a digit, space, or plus or minus ‘ sign in the parameter value.

“V requires entry of a letter [A to Z] in the parameter value.

« Allows but does not require a letter to be entered in the parameter value.

• “&* requires entry of any character or space in the parameter value.

•   “C” allows but does not require entry of any character or space in the parameter value.

•   “.-/” act as literal or “hard-coded* separator characters. Separator characters contained in an edit mask will appear in the value entry field on the prompting dialog box. Or, if you place the parameter field.on.the report, the separator characters appear in the field object, like this for example: LLLL/0000. This example depicts an edit mask that requires four letters followed by four numbers.

Share.

About Author

Leave A Reply