The following are all of the VBA functions, sorted by category, that are available in Access 2003. Click one of the following links to see a topic that gives detailed information about how to reference the function. Note that the link will take you to the Microsoft Developer Network (MSDN) Web site.

Arrays functions

• LBound Function
• UBound Function

Conversion functions

• Asc Function
• Chr Function
• Day Function
• FormatCurrency Function
• FormatDateTime Function
• FormatNumber Function
• FormatPercent Function
• Hex Function
• Hour Function
• Oct Function
• Str Function
• Val Function
• GUIDFromString Function
• StringFromGUID Function

 Back to top

Database functions

• CurrentUser Method
• Eval Function
• HyperlinkPart Method
• IMEStatus Function
• Partition Function

Date/Time functions

• Date Function
• Minute Function
• Month Function
• MonthName Function
• Now Function
• Second Function
• Time Function
• Timer Function
• TimeSerial Function
• TimeValue Function
• Weekday Function
• WeekdayName Function
• Year Function

 Back to top

Domain aggregate functions

• DAvg Function
• DCount Function
• DFirst Function
• DLast Function
• DLookup Function
• DMax Function
• DMin Function
• DStDev Function
• DStDevP Function
• DSum Function
• DVar Function
• DVarP Function

 Back to top

Error handling functions

• CVErr Function
• DateAdd Function
• DateDiff Function
• Error Function
• FileDateTime Function

Financial functions

• DDB Function
• FV Function
• IPmt Function
• IRR Function
• MIRR Function
• NPer Function
• NPV Function
• Nz Function
• Pmt Function
• PPmt Function
• PV Function
• Rate Function
• SLN Function
• SYD Function

 Back to top

General functions

• QBColor Function
• RGB Function

Inspection functions

• IsArray Function
• IsEmpty Function
• IsError Function
• IsMissing Function
• IsNull Function
• IsNumeric Function
• IsObject Function
• TypeName Function
• VarType Function

 Back to top

Math functions

• Abs Function
• Atn Function
• Cos Function
• DatePart Function
• DateSerial Function
• DateValue Function
• Exp Function
• Log Function
• Rnd Function
• Round Function
• Sgn Function
• Sin Function
• Sqr Function
• Tan Function

 Back to top

Messages functions

• InputBox Function
• MsgBox Function

Program flow functions

• Choose Function
• IIf Function
• Switch Function

SQL aggregate functions

• Avg Function
• Count Function
• Max function
• Min function
• StdDev Function
• StdDevP Function
• Sum Function
• Var Function
• VarP Function

 Back to top

Text functions

• Different Formats for Different String Values (Format Function)

• Format Function
• InStr Function
• InStrRev Function
• LCase Function
• Left Function
• Len Function
• LTrim, RTrim, and Trim Functions
• Mid Function
• Replace Function
• Right Function
• Space Function
• StrComp Function
• StrConv Function
• String Function
• StrReverse Function
• UCase Function

 Back to top