CAUTION If you change any of the validation rules in table Design view, these changes are in Microsoft Office

Generating PDF 417 in Microsoft Office CAUTION If you change any of the validation rules in table Design view, these changes are

enforced on controls based on those fields, even if you added the controls to the form before making the changes

Part II:

Results Control can receive focus The data is displayed normally and can be copied, but can t be edited Control can receive focus Use this combination to allow editing of objects in unbound object frames The data is displayed normally and can be copied or edited Control cannot receive focus Data is displayed normally, but can t be copied or edited Control cannot receive focus Control and data both appear dimmed and are disabled

TABLE 12-1

You can combine property settings to accomplish specific purposes For example, if you want the form to be read-only, set Allow Edits, Allow Additions, and Allow Deletions all to No Combining the Enabled and Locked property settings for a control can create custom results as shown in Table 12-1 You can also combine the Enabled and Tab Stop properties If you set Enabled to Yes and Tab Stop to No, the control can t be selected by pressing TAB, but it can still be selected by clicking the control or its label

Attaching macros or event procedures to form and control event properties can give you additional flexibility and power over data entry For example, you can require that at least two of three fields must be filled in before you can save the record You would also use an event procedure if the validation refers to controls on other forms or if the control contains a function If you want to validate the data before the whole record is updated, add the procedure to a form event To validate the data before moving to the next control, add the procedure to a control event Table 12-2 shows a few of the form and control events that you can use for data validation See 18 for more information about events and their sequence of occurrence, and how to make the macros that will carry out the actual validation

Event Before Update (form) On Delete (form) Before Update (control) On Exit (control) TABLE 12-2 Description Rule enforced before saving new or changed data in a record Rule enforced before deleting a record Rule enforced before saving new or changed data in a control Rule enforced before leaving control

12:

Summary

You might never want to add hyperlinks or a calendar to a form but, if you do, this chapter contains all the information you need to add these and other special controls The most important aspect of form design isn t What new and exotic things can I add to it but, rather, What does the user need to see and know to do his or her job One of the most flexible features of form design is the capability to link subforms to a main form to show related data from more than one table You saw examples of using subforms in this and the preceding chapter where records from a table on the many side of a one-to-many relationship were displayed in a subform with the data from the one side in the main form Starting with the next chapter, you learn how to create reports for distributing information to outside users You also make further use of the Police database introduced in this chapter, as well as continue to see examples using the Home Tech Repair database You create reports first with the help of the Report Wizard, and then from scratch in report Design view 14 also discusses special reports that group and summarize data, or print envelopes and mailing labels