Use data validation rules to control the type of data or the values that users enter into a cell. One example of validation is a drop-down list (also called a drop-down box or drop-down menu). …

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 use data validation to restrict the type of data or values that users enter into cells. This is an advanced topic on data validation. For an introduction to data validation, and how to …

By adding data validation to controls in your form template, you can ensure that the data that you collect is accurate and consistent, and that it conforms to any standards that are already in use …

Adding validation rules to controls in a form template ensures that the data collected is accurate and consistent. When you add a text control, users can type anything into it.

You can validate data in Access desktop databases as you enter it by using validation rules. Validation rules can be set in either table design or table datasheet view.

You can find cells in a workbook that contain data validation by using the Go To Special dialog box. On the Edit menu, point to Find, and then click Go To. Click Special. Select Data …

In addition to validation and formatting rules, you can also add rules to form templates to perform other actions, such as switch views, set a field value, or query or submit to a data connection.

The Field or Group Properties dialog box is where you can view or set the properties for a field or group in your form template's data source. You can also use this dialog box to specify any …

Excel displays a red circle around any cells that contain invalid data. All cells that don't meet their data validation criteria are circled, including values that were typed, copied, or filled in the …