Skip to main content

Access Junkie - MVP Alumnus

Home
Access Inside Out Books
Access 2010 FAQ
Access 2007 Training
Access 2007 FAQ
Access 2007 KB Articles
Technical Articles
Links
MSDN Articles
Blogs
Forums
Contact Us
About Us
Member Login
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