Microsoft Office Tutorials and References
In Depth Information
Two types of validation are available, and either one or both can be applied to a field. The first,
implemented by selecting the A Value Is Required for This Field option, is used simply to ensure
that a field is not left blank.
The second type of validation looks at the data in the field and makes sure that it meets a defined
criterion. To implement this type of validation, select the Validate This Field Before Closing the
Form option and click the Edit button to define the validation formula. The procedure for this is
very similar to that for defining a formula for a formula field as covered earlier in this chapter, and
is not repeated here. The one essential difference is that you will create a logical formula, one that
evaluates to True (validation successful) or False (validation failed). The syntax for these formulas
are the same as for the VBA logical formulas that were covered in Chapter 23.
The final step in defining validation rules is to specify the message to display when the validation
fails. You can simply type the message in the Display This Message... box or use the Edit button to
define a more complex message.
Setting Form Properties
The properties for a form are located on the Properties page when the form is open in the Forms
Designer. This page is shown in Figure 27.12. These properties apply to the form as a whole rather
than to a specific page or control.
Setting form properties on the Properties page.