Access 2010 FAQ
How do you create a table level validation rule in a web table?
The entry point to create a table level validation rule in a web table in Access 2010 can be a little hard to find. To create a new table level validation, open your web table in Datasheet view. Note that if you are working in a published web application, you must be currently connected to the Access Services site in order to make this schema change.
Now click the Validation button in the Field Validation group on the Fields contextual ribbon tab. Access displays a drop-down list of four options. Click Record Validation Rule as shown in the following screenshot.
Access opens up the revamped Expression Builder dialog box, as shown below. You can enter the table validation rule expression you'd like to use in this dialog box. Click OK to save your changes when you are finished. Note that if you use an expression that is not web compatibile, Access displays a notification message and prevents you from saving your changes.
I recommend you always define a custom validation message whenever you create validation rules. To define a table level validation rule message, click the Validation button in the Field Validation group on the Fields contextual ribbon tab and then click Record Validation Message. (You can see this option in the first screenshot above.)
Access now opens the Enter Validation Message dialog box, as shown in the following screenshot.
Type in the custom validation message you'd like to use and then click OK to save your changes.
See more tips and tricks like this in my book: Microsoft Access 2010 Inside Out
Back to FAQ main page