Functions (Category List)
The following list contains topics that describe common functions used in Microsoft Office Access 2007 expressions.
ActiveX
CreateObject Function
GetObject Function
.gif "Bb735932.TopPageIcon_ZA10077668(en-us,office.12).gif")
Top of Page
Application
Command Function
Shell Function
Top of Page
Arrays
Array Function
Filter Function
Join Function
LBound Function
Split Function
UBound Function
Top of Page
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
Top of Page
Database
CurrentUser Method
DDEInitiate Method
DDERequest Method
Eval Method
HyperlinkPart Method
Partition Function
Top of Page
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
Top of Page
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
Top of Page
Error Handling
CVErr Function
Error Function
IsError Function
Top of Page
File Input/Output
EOF Function
FreeFile Function
Input Function
Loc Function
LOF Function
Seek Function
Top of Page
File Management
CurDir Function
Dir Function
FileAttr Function
FileDateTime Function
FileLen Function
GetAttr Function
Top of Page
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
Top of Page
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
Top of Page
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
Top of Page
Messages
InputBox Function
MsgBox Function
Top of Page
Miscellaneous
CallByName Function
IMEStatus Function
QBColor Function
RGB Function
Spc Function
Tab Function
Top of Page
Program Flow
Choose Function
DoEvents Function
IIf Function
Switch Function
Top of Page
SQL Aggregate
Avg Function
Count Function
Max Function
Min Function
StDev Function
StDevP Function
Sum Function
Var Function
VarP Function
Top of Page
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
Top of Page
See Also