Functions (alphabetical list)

The following topics describe common functions used in Access expressions.

Common Access expression functions

• Abs function
• Array function
• Asc function
• Atn function
• Avg function
• CallByName function
• CBool function
• CByte function
• CCur function
• CDate function
• CDbl function
• CDec function
• Choose function
• Chr function
• CInt function
• CLng function
• Command function
• Cos function
• Count function
• CreateObject function
• CSng function
• CStr function
• CurDir function
• CurrentUser method
• CVar function
• CVErr function
• Date function
• DateAdd function
• DateDiff function
• DatePart function
• DateSerial function
• DateValue function
• DAvg function
• Day function
• DCount method
• DDB function
• DDEInitiate method
• DDERequest method
• DFirst method
• Dir function
• DLast method
• DLookup method
• DMax method
• DMin method
• DoEvents function
• DStDev method
• DStDevP method
• DSum method
• DVar method
• DVarP method
• Environ function
• EOF function
• Error function
• EuroConvert method
• Eval method
• Exp function
• FileAttr function
• FileDateTime function
• FileLen function
• Filter function
• Fix function
• Format function
• FormatCurrency function
• FormatDateTime function
• FormatNumber function
• FormatPercent function
• FreeFile function
• FV function
• GetAllSettings function
• GetAttr function
• GetObject function
• GetSetting function
• GUIDFromString method
• Hex function
• Hour function
• HtmlEncode method
• HyperlinkPart method
• IIf function
• IMEStatus function
• Input function
• InputBox function
• InStr function
• InStrRev function
• Int function
• IPmt function
• IRR function
• IsArray function
• IsDate 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 function
• Max function
• Mid function
• Min function
• Minute function
• MIRR function
• Month function
• MonthName function
• MsgBox function
• Now function
• NPer function
• NPV function
• Nz method
• Oct function
• Partition function
• PlainText method
• Pmt function
• PPmt function
• PV function
• QBColor function
• Rate function
• Replace function
• RGB function
• Right function
• Rnd function
• Round function
• RTrim function
• Second function
• Seek function
• Sgn function
• Shell function
• Sin function
• SLN function
• Space function
• Spc function
• Split function
• Sqr function
• StDev function
• StDevP function
• Str function
• StrComp function
• StrConv function
• String function
• StringFromGUID method
• StrReverse function
• Sum function
• Switch function
• SYD function
• Tab function
• Tan function
• Time function
• Timer function
• TimeSerial function
• TimeValue function
• Trim function
• TypeName function
• UBound function
• UCase function
• Val function
• Var, VarP functions
• VarType function
• Weekday function
• WeekdayName function
• Year function

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.