Functions (category list)
The following list contains topics that describe common functions used in Access expressions.
ActiveX
Application
Arrays
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
File input/output
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
Miscellaneous
Program flow
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.
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for