Use Validation Rules and Validation Text in Access

Set validation rules and validation text for a particular field to improve the quality of data entered. This example requires the data entry person to enter a date matching today's date or earlier.