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

Chapter 41. Creating and Using Custom Fields > Creating a Formula Custom Field

Creating a Formula Custom Field

The other special Outlook field type is the formula field, which has some resemblance to an Excel formula, or an Access calculated field. Formula fields are started in a similar way to combination fields. Once you have the New Field dialog box open, implement the following steps to create a field that displays the number of days to Christmas:

  1. Place a TextBox control on the form, as in earlier examples.

  2. Select Formula as the field type.

  3. Click the Edit button to open the Formula Field dialog box.

  4. Use the Function button to select the functions to use in the field, and the Field button to select any fields needed to replace the function argument placeholders. (Or, if you prefer, you can type the entire expression directly.) Figure 41.14 shows the DateSerial function being selected (one of the date functions needed to create this formula).

  5. Figure 41.15 shows the completed formula in the Formula Field dialog box.

  6. The resulting formula field with the days to Christmas calculation is shown in form view in Figure 41.16. The entire formula is DateDiff("d", Date(), DateSerial(Year(Date()),12,25)).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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