The following are all of the VBA functions, sorted alphabetically, 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.

A–C   D   E-G   H–L   M–Q   R–S   T–Y

A–C

• Abs Function
• Array Function
• Asc Function
• Atn Function
• Avg Function
• CallByName Function
• Choose Function
• Chr Function
• Command Function
• Cos Function
• Count Function
• CreateObject Function
• CurDir Function
• CurrentUser Method
• CVErr Function

 Back to top

D

• Date Function
• DateAdd Function
• DateDiff Function
• DatePart Function
• DateSerial Function
• DateValue Function
• DAvg Function
• Day Function
• DCount Function
• DDB Function
• DDE Function
• DDEInitiate Function
• DDERequest Function
• DFirst Function
• Different Formats for Different String Values (Format Function)
• Dir Function
• DLast Function
• DLookup Function
• DMax Function
• DMin Function
• DoEvents Function
• DStDev Function
• DStDevP Function
• DSum Function
• DVar Function
• DVarP Function

 Back to top

E–G

• Environ Function
• EOF Function
• Error Function
• EuroConvert Function
• Eval Function
• Exp Function
• FileAttr Function
• FileDateTime Function
• FileLen Function
• Filter Function
• Format Function
• FormatCurrency Function
• FormatDateTime Function
• FormatNumber Function
• FormatPercent Function
• FreeFile Function
• FV Function
• GetAllSettings Function
• GetAttr Function
• GetObject Function
• GetSetting Function

 Back to top

H–L

• Hex Function
• Hour Function
• HyperlinkPart Method
• IIf Function
• IMEStatus Function
• Input Function
• InputBox Function
• InStr Function
• InStrRev Function
• Int, Fix Functions
• IPmt Function
• IRR Function
• IsArray Function
• IsEmpty Function
• IsError Function
• IsMissing Function
• IsNull Function
• IsNumeric Function
• IsObject Function
• Join Function
• LBound Function
• LCase Function
• Left Function
• Len Function
• Loc Function
• LOF Function
• Log Function
• LTrim, RTrim, and Trim Functions

 Back to top

M–Q

• MacID Function
• MacScript Function
• Max function
• Mid Function
• Min function
• Minute Function
• MIRR Function
• Month Function
• MonthName Function
• MsgBox Function
• Now Function
• NPer Function
• NPV Function
• Oct Function
• Partition Function
• Pmt Function
• PPmt Function
• PV Function
• QBColor Function

 Back to top

R–S

• Rate Function
• Replace Function
• RGB Function
• Right Function
• Rnd Function
• Round Function
• Second Function
• Seek Function
• Sgn Function
• Shell Function
• Sin Function
• SLN Function
• Space Function
• Spc Function
• Split Function
• Sqr Function
• StdDev Function
• StdDevP Function
• Str Function
• StrComp Function
• StrConv Function
• String Function
• StrReverse Function
• Sum Function
• Switch Function
• SYD Function

 Back to top

T–Y

• Tab Function
• Tan Function
• Time Function
• Timer Function
• TimeSerial Function
• TimeValue Function
• TypeName Function
• UBound Function
• UCase Function
• Val Function
• Var Function
• VarP Function
• VarType Function
• Weekday Function
• WeekdayName Function
• Year Function

 Back to top