Search results
You can use the Validation Rule property and the Validation Text property of a form control to validate data that is input to that control and to help users who input data that is not valid.
You can ensure clearing the validated cell is always permitted (and keep "Ignore blanks" deselected as required) by specifically allowing an empty string in the validation formula. e.g. if the validated cell address in your example was F8, then the validation formula would be =OR(F8="",E8<>"")
25 lut 2005 · If you absolutely require the control to be filled in, and it's bound to a table field, do the validation at the table level instead. In design view in the table, select the field. In the properties change Required to Yes, and Allow Null to No.
In some versions of Access, you will not be able to leave the field blank once you add the validation rule, i.e. you must enter something that satisfies the rule. If you need to be able to leave the field blank, add OR Is Null to your rule. (Some versions accept Nulls anyway, but we recommend you make it explicit for clarity and consistency.)
27 paź 2020 · I'm trying to create a data validation error message, where by the message will appear when the user leaves a certain cell blank. I want the user to only be able to enter text within the required cell too.
5 lip 2005 · Blank can be either Null or an empty String "" depending on how you set the Field in the Table (check Access Help on the Properties "Required" and "Allow Zero Length"). Depending on how you set the 2 Properties, you can use different Boolean expressions.
12 gru 2013 · I'd like to filter out records which have a specific field blank. I tried Not "" in the criteria row for that field, but the results view still shows records where that field is blank. It is my understanding that this is a case of a blank string, not a Null value.
