When the user skips a field, the exit macro doesn't run, and there's no validation.Ī straightforward approach is to force the user to work through the fields in the form in turn, validating the result of each field as the user leaves it. But if the user moves about the form with the mouse, he can skip fields altogether. If the user uses the keyboard to move from field to field, the exit macros can validate each field. An exit macro is especially useful for checking that the contents of the field are suitable and for displaying a message box explaining any problems to the user.Įxit macros are almost ideal for ensuring that the user fills in all the required fields in the formbut only almost. You can also control the default entry, the length of the entry, and the format in which it is entered.įor any form field, you can run a macro on entry (when the user moves the selection to the form field), on exit (when the user moves the selection to another form field), or both. The Solution:įor a text form field, you can control what the user enters to some extent by specifying the type of text ("Regular text," "Number," "Date," "Current date," "Current time," or "Calculation") in the Type drop-down list in the Text Form Field Options dialog box. But they're still leaving some vital fields blank and filling in others incorrectly.
Right, protecting the form has prevented my colleagues from deleting the sections that don't apply to them.
0 kommentar(er)
