• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 10. Using Procedures to Customiz... > Using Functions to Fulfill Your Wish...

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 the string character by character. You get a chance for some hands-on experience with this version. Take a look at the following code:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint