Примери за използване на Validation rule на Английски и техните преводи на Български
{-}
-
Colloquial
-
Official
-
Medicine
-
Ecclesiastic
-
Ecclesiastic
-
Computer
Where you can use validation rules.
These data validation rules will not be supported in earlier versions of Excel.
Where you can use validation rules.
The Validation Rule control property works like a field validation rule.
The table should already have a record validation rule.
These data validation rules will not be saved.
You can use wildcard characters in your validation rules.
Usually, a record validation rule compares the values of two or more fields.
Use the Expression Builder to create your validation rule.
In Excel 97-2007, this type of data validation rule is not supported and won't be available.
Use the Expression Builder to create your validation rule.
For example, if the validation rule is>10, themessage might be“Enter a value that is less than 10.”.
Specifies that all parts of the validation rule must be true.
Unlike a field validation rule, a record validation rule refers to other fields in the same table.
Notes: The following field types do not support validation rules: AutoNumber.
Then, create a record validation rule to make sure that the data in the original fields is unique.
Specifies that some but not all parts of the validation rule must be true.
A record validation rule checks input to one or more fields is applied when the focus leaves the record.
The language also supports modeling of relationships and data validation rules.
You can also use expressions in the Validation Rule property for a table field.
You can compare values across different fields using a record validation rule.
A validation rule is one way to restrict input in a table field or a control(such as a text box) on a form.
Change the metadata, such as adding anddeleting columns, and modifying validation rules;
Validation rule and validation text examples Syntax examples for common validation rule operators.
Change the metadata, such as adding anddeleting columns, and modifying validation rules;
Note: You can also use a validation rule to display a message when a user enters incorrect values into a form.
In the Field Validation group, click Validation, and then click Record Validation Rule.
Field Validation Rule You can use a validation rule to specify a criterion that all valid field values must meet.
For a more thorough explanation of validation, see the article Restrict data input by using a validation rule.
Record Validation Rule You can use a record validation rule to specify a condition that all valid records must satisfy.