This is a meaningful total, e

Access validating data entry

Creating a Custom Input Mask Expression If your data doesn't fit any of the predefined input masks, you need to create a custom mask that suits your needs. This section needs additional citations for verification. Helping Users with Text Prompts You can prevent improper entries to a certain extent by adding text that provides details on what is allowable inside a particular cell. This is a string that appears in the Access status bar when users enter the field.

The Post-validation action sends feedback to help enforce validation. Fortunately, you have a bit more control when it comes to preventing improper data entry.

So if the users don't now enough to do that, they will be caught in a frustrating loop. Notice the labels added beside the Interest Rate and Term text boxes that specify to the users that they must enter the interest rate per annum and the term in years.

For example you

For example, you might use parentheses as literals to surround the area code portion of a phone number. Regular expressions are effective ways of implementing such checks. Data that falls outside an allowable range. If the syntax for validation rules looks cryptic, see the section What you can put in a validation rule for an explanation of the syntax and some example validation rules. Close the property sheet to apply the data validation rule.

However, you replies got me thinking about different ways of approaching this, and I think it got it to work like I want using the AfterUpdate event instead. Hash totals This is just a batch total done on one or more numeric fields which appears in every record. Near the end of the plan year, they will start to generate annual records for next year. To add validation rules to a form, you open the form in Layout view and add rules to the properties of individual controls.

Regular expressions are effective ways

Referential integrity In modern Relational database values in two tables can be linked through foreign key and primary key. Data types are not optional, and provide the most basic type of data validation. As with data validation, however, these prompts are not guaranteed to work every time or even most of the time. Data must conform to a specified format.