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

Functions

Functions return values to their names; functions can take the place of identifiers in expressions. One of the most common functions used in VBA/Jet expressions is Now, which returns to its name the date and time from your computer’s system clock. If you type Now as the Default Value property of a table’s Date/Time field, for example, 3/15/2003 9:00 appears in the field when you change to Datasheet view (at 9:00 a.m. on March 15, 2003).

VBA defines about 150 individual functions. The following list groups functions by purpose:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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