Access 2002 Programming by Example

Using Functions to Fulfill Your Wish List of Features Access Forgot

By now you’re beginning to realize the power that is available to you through programming. If you are like most users, you have a wish list of features that you would like to see in a database. If you can’t find these features in any help menu or tutorial, it’s time to try to create them yourself. If you create a feature as a function, then you can use it practically anywhere in the database.

At the beginning of this chapter, you were promised a function that would capitalize the first letter of each word in a string. Two versions are presented for analysis. The first version “hops” words by using the InStr function to find the spaces in the string. The second version analyzes ...