Automatically Create Salutation

If you want consistency, it's a good idea to have the program construct certain things like salutations.  This also makes users happier because they have to type less. 

Following is an example of what can be done with only a few words of programming in Access.  The salutation is created automatically as soon as the user tabs off the Last Name field:

If both parent's names are put in, the program creates a salutation beginning with "Dear Mr. and Mrs...."

 
If only the father's name is put in, the program creates a salutation beginning with "Dear Mr...."

 
If only the mother's name is put in, the program creates a salutation beginning with "Dear Ms...."

Of course, if the standard salutation isn't appropriate for a certain customer, then the user can change it to whatever is correct (unless you choose not to allow them to).

This technique can be used for a number of purposes, for example, to create a "keyword" that's a combination of last name, date created, and sales rep initials - or anything you want.


Peck Tech Designs - consultants providing creative custom software development, integration, Internet web site programming, database design, and application and data conversion to clients in Connecticut and throughout the USA.

Copyright Rachel Peck 2003 - all rights reserved
Terms and Conditions of use