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

Access String Functions

The simple reason why it is a good idea to use built-in string functions is that they are very useful to anyone who wants to have a good understanding of development using Microsoft Access. Databases are about data and how data can be manipulated. Queries can manipulate data, but queries have limitations. Suppose you want to pull the first name out of a full name in a field located in a table having 30,000 records. How can you do that in a query without using a string function? You can use an SQL string in VBA, but even there, the best way to extract the data is to use a string function. You also can benefit from using string functions in your own functions to create utilities custom made for your applications.

String functions are not the only built-in (intrinsic) Access functions that are useful, but they could very possibly be the functions that you use the most. Like other intrinsic functions, string functions have arguments separated by commas. Some arguments are optional, others are required. Each argument can have its own data type. For example, in the left function, the first argument requires a string and the second argument requires a number (long integer). Thus, the syntax is as follows:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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