DISPLAY RECORD-SPECIFIC MESSAGES 

Want an easy way to "talk" to the people who use your forms to add or edit data? 

Use an "immediate IF" (IIf) function to display a custom message based on the contents of a given field (or fields). 

Don't think of it as a data-validation tool as much as a subtle way to ping your users when a key value is still empty, too low, too high, or significant for some other reason. 

For example, suppose your form displays a field named Amount Of Sale. You might want to display a congratulatory message when the amount entered in that field is over some fixed amount, such as $500. 

Start by creating a text box control and naming it Calculated Way To Go. Open its Properties window, select the Data tab, and click the Control Source property. 

Enter an IIf function like the one shown below. =IIf([Amount of Sale] > 500,"Way to go!","") When the user adds the information to the field, the text box will display your message depending on the amount entered. 

Of course, instead of "nothing," you can specify your own phrase for values of $500 or less.

<<<Back Home Next>>>