Functions (category list)

The following list contains topics that describe common functions used in Access expressions.

ActiveX

• CreateObject function
• GetObject function

Application

• Command function
• Shell function

Arrays

• Array function
• Filter function
• Join function
• LBound function
• Split function
• UBound function

Conversion

• Asc function
• CBool function
• CByte function
• CCur function
• CDate function
• CDbl function
• CDec function
• Chr function
• CInt function
• CLng function
• CSng function
• CStr function
• CVar function
• Day function
• EuroConvert method
• FormatCurrency function
• FormatDateTime function
• FormatNumber function
• FormatPercent function
• GUIDFromString method
• Hex function
• Nz method
• Oct function
• Str function
• StringFromGUID method
• Type Conversion functions
• Val function

Database

• CurrentUser method
• DDEInitiate method
• DDERequest method
• Eval method
• HyperlinkPart method
• Partition function

Date/Time

• Date function
• DateAdd function
• DateDiff function
• DatePart function
• DateSerial function
• DateValue function
• Day function
• Hour 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

Domain aggregate

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

Error handling

• CVErr function
• Error function
• IsError function

File input/output

• EOF function
• FreeFile function
• Input function
• Loc function
• LOF function
• Seek function

File management

• CurDir function
• Dir function
• FileAttr function
• FileDateTime function
• FileLen function
• GetAttr function

Financial

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

Inspection

• Environ function
• GetAllSettings function
• GetSetting function
• IsArray function
• IsDate function
• IsEmpty function
• IsError function
• IsMissing function
• IsNull function
• IsNumeric function
• IsObject function
• TypeName function
• VarType function

Math

• Abs function
• Atn function
• Cos function
• Exp function
• Fix function
• Int function
• Log function
• Rnd function
• Round function
• Sgn function
• Sin function
• Sqr function
• StDev function
• StDevP function
• Tan function

Messages

• InputBox function
• MsgBox function

Miscellaneous

• CallByName function
• IMEStatus function
• QBColor function
• RGB function
• Spc function
• Tab function

Program flow

• Choose function
• DoEvents function
• IIf function
• Switch function

SQL aggregate

• Avg function
• Count function
• Max function
• Min function
• StDev function
• StDevP function
• Sum function
• Var function
• VarP function

Text

• Format function
• HtmlEncode method
• InStr function
• InStrRev function
• LCase function
• Left function
• Len function
• LTrim function
• Mid function
• PlainText method
• Replace function
• Right function
• RTrim function
• Space function
• StrComp function
• StrConv function
• String function
• StrReverse function
• Trim function
• UCase 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.