Alphabetical A - M

ABS	Returns the absolute value of a number (Variant).
AND	The logical 'AND' operator (Boolean).
APPACTIVATE	Activates an application or window currently running on Windows.
ARRAY	Returns an array containing the given values (Variant).
ASC	Returns the ASCII / ANSI number for the first character in a text string (Integer).
ASCW	Returns the Unicode number for the first character in a text string (Integer)
ATN	Returns the arc-tangent of a number in radians (Double).
BEEP	Produces a single beep noise.
CALL	Transfers control to a subroutine or function.
CALLBYNAME	Returns, sets or executes a method or property of an object (Variant).
CBOOL	Returns the expression converted to a boolean data type (Boolean).
CBYTE	Returns the expression converted to a byte data type (Byte).
CCUR	Returns the expression converted to a currency data type (Currency).
CDATE	Returns the expression converted to a date data type (Date).
CDBL	Returns the expression converted to a double data type (Double).
CDEC	Returns the expression converted to a decimal variant-subtype (Variant).
CHDIR	Defines the current default directory.
CHDRIVE	Defines the current default drive.
CHOOSE	Returns the value from a list of values based on an index number (Variant).
CHR	Returns the character with the corresponding ASCII / ANSI number (Variant / String).
CHRW	Returns the character with the corresponding Unicode number (Variant / String)
CINT	Returns the expression converted to an integer data type (Integer).
CLNG	Returns the expression converted to a long data type (Long).
CLNGLNG	Returns the expression converted to a longlong (64 bit platform) data type.
CLNGPTR	Returns the expression converted to a longptr data type.
CLOSE	Closes a text file or CSV file.
COMMAND	Returns the argument or command-line string passed when an Access application starts (Variant).
COS	Returns the cosine of an angle in radians (Double).
CREATEOBJECT	Returns a reference after creating a new ActiveX or OLE object (Variant).
CSNG	Returns the expression converted to a single data type (Single).
CSTR	Returns the expression converted to a string data type (String).
CURDIR	Returns the current path of a given drive (Variant / String).
CVAR	Returns the expression converted to a variant data type (Variant).
CVDATE	Returns the expression converted to a variant date subtype (Variant).
CVERR	Returns a specific type of error (Variant).
DATE - Function	Returns the current system date (Variant / Date).
DATE - Statement	Defines the current system date.
DATEADD	Returns the date with a specified time interval added (Date).
DATEDIFF	Returns the number of a given time interval between two specified dates (Long).
DATEPART	Returns the specified part of a given date (Variant / Integer).
DATESERIAL	Returns the date given a year, month and day (Date).
DATEVALUE	Returns the date given a string representation of a date (Date).
DAY	Returns the day from a given date (Integer).
DDB	Returns the depreciation of an asset in a single period (double or higher declining balance method) (Double).
DELETESETTING	Removes (or deletes) a key or section from the registry.
DIR	Returns the name of a file or directory matching a pattern or attribute (Variant / String).
DOEVENTS	Pauses execution to let the system process other events.
ENVIRON	Returns information about the current operating system environment (String).
EOF	Returns the value indicating if the end of a file has been reached (Boolean).
EQV	The logical equivalence operator.
ERASE	Reinitialises the elements of an array.
ERROR - Function	Returns the error message corresponding to a given error number (String).
ERROR - Statement	(Err.Raise) Generates an error.
EXP	Returns the base of natural logarithm raised to a power (Double).
FILEATTR	Returns the file mode of the specified open file (Long).
FILECOPY	Copies a file from one directory to another.
FILEDATETIME	Returns the date and time when a file was created or last modified (Date).
FILELEN	Returns the length of a file in bytes (Long).
FILTER	Returns an array containing a subset of values that contain a substring (Variant).
FIX	Returns the integer portion of a number (data type).
FORMAT	Returns the text string of a number or date in a particular format (Variant / String).
FORMATCURRENCY	Returns the expression formatted as a currency value (String).
FORMATDATETIME	Returns the expression formatted as a date or time (String).
FORMATNUMBER	Returns the expression formatted as a number (String).
FORMATPERCENT	Returns the expression formatted as a percentage (String).
FREEFILE	Returns the next valid free file number (Integer).
FV	Returns the future value of a series of equal cash flows at regular intervals (Double).
GET	Reads data from a text file into a record.
GETALLSETTINGS	Returns the list of key settings and their values from the registry (Variant).
GETATTR	Returns the attributes of a given file or directory (Integer).
GETOBJECT	Returns the reference to an object provided by an ActiveX component.
GETSETTING	Reads from the registry and returns the value or key from the registry (String).
GOTO	Transfers control to the subroutine indicated by the line label.
HEX	Returns the number converted to hexadecimal (Variant / String).
HOUR	Returns the hour from a given time (Integer).
IIF	Returns one of two parts, depending on the evaluation of an expression.
IMESTATUS	Returns the current Input Method Editor mode of Microsoft Windows (Integer).
IMP	The logical implication from two values (Variant).
IMPLEMENTS	Specifies an interface or class that can be implemented in a class module.
INPUT - Function	Reads a number of characters from a file (Variant / String).
INPUT - Statement	Reads data from a file and assigns the data to a list of variables (Long).
INPUTBOX	Displays a dialog box allowing the user to enter some information (String).
INSTR	Returns the position of a substring within a larger string (Variant / Long).
INSTRREV	Returns the position of a substring within a larger string, starting at the end (Long).
INT	Returns the integer portion of a number (data type).
IPMT	Returns the interest paid in a given period in a series of equal cash flows at regular intervals (Double).
IRR	Returns the interest rate for a series of unequal cash flows at regular intervals (implicit reinvestment rate) (Double).
IS	Compares two object reference variables.
ISARRAY	Returns the value True or False depending if the expression is an array (Boolean).
ISDATE	Returns the value True or False depending if the expression is a date (Boolean).
ISEMPTY	Returns the value True or False depending if the Variant variable has been initialised (Boolean).
ISERROR	Returns the value True or False depending if the expression is an error (Boolean).
ISMISSING	Returns the value True or False depending if the optional argument has been passed to a procedure (Boolean).
ISNULL	Returns the value True or False depending if the expression contains no data (Boolean).
ISNUMERIC	Returns the value True or False depending if the expression is a number (Boolean).
ISOBJECT	Returns the value True or False depending if the identifier represents an object (Boolean).
JOIN	Returns a text string containing all the elements in an array (String).
KILL	Deletes an existing file.
LBOUND	Returns the lower limit in a given dimension of an array (Long).
LCASE	Returns the text string with all characters converted to lowercase (Variant / String).
LEFT	Returns a substring from the left of a string (Variant / String).
LEN	Returns the number of characters in a string (Long).
LET	Computes a value and assigns it to a new variable.
LIKE	The pattern matching operator.
LINE INPUT	Reads a single line from a file opened with Sequential access (String).
LOAD	Loads an object but doesn't display it.
LOADPICTURE	Loads a picture from a file into a Picture or Image control (IPictureDisp).
LOC	Returns the current read/write position within an open file (Long).
LOCK	Locks access to parts of a file for other processes.
LOF	Returns the length or size of an open file, in bytes (Long).
LOG	Returns the natural logarithm of a number (Double).
LSET	Left aligns a string within a string variable.
LTRIM	Returns the text string without leading spaces (Variant / String).
MACID	Converts a four character constant to a value that can be used by Dir, Kill, Shell and AppActivate.
MID - Function	Returns a substring from the middle, left or right of a string (Variant / String).
MID - Statement	Replaces a specified number of characters with characters from another string.
MINUTE	Returns the minutes from a given time (Integer).
MIRR	Returns the interest rate for a series of unequal cash flows at regular intervals (explicit reinvestment rate) (Double).
MKDIR	Creates a new directory.
MOD	Returns the remainder after division operator (Integer).
MONTH	Returns the month from a given date (Integer).
MONTHNAME	Returns the month as a string (String).
MSGBOX	Displays a dialog box displaying a message to the user (Integer).

ABS Returns the absolute value of a number (Variant).
AND The logical 'AND' operator (Boolean).
APPACTIVATE Activates an application or window currently running on Windows.
ARRAY Returns an array containing the given values (Variant).
ASC Returns the ASCII / ANSI number for the first character in a text string (Integer).
ASCW Returns the Unicode number for the first character in a text string (Integer)
ATN Returns the arc-tangent of a number in radians (Double).
BEEP Produces a single beep noise.
CALL Transfers control to a subroutine or function.
CALLBYNAME Returns, sets or executes a method or property of an object (Variant).
CBOOL Returns the expression converted to a boolean data type (Boolean).
CBYTE Returns the expression converted to a byte data type (Byte).
CCUR Returns the expression converted to a currency data type (Currency).
CDATE Returns the expression converted to a date data type (Date).
CDBL Returns the expression converted to a double data type (Double).
CDEC Returns the expression converted to a decimal variant-subtype (Variant).
CHDIR Defines the current default directory.
CHDRIVE Defines the current default drive.
CHOOSE Returns the value from a list of values based on an index number (Variant).
CHR Returns the character with the corresponding ASCII / ANSI number (Variant / String).
CHRW Returns the character with the corresponding Unicode number (Variant / String)
CINT Returns the expression converted to an integer data type (Integer).
CLNG Returns the expression converted to a long data type (Long).
CLNGLNG Returns the expression converted to a longlong (64 bit platform) data type.
CLNGPTR Returns the expression converted to a longptr data type.
CLOSE Closes a text file or CSV file.
COMMAND Returns the argument or command-line string passed when an Access application starts (Variant).
COS Returns the cosine of an angle in radians (Double).
CREATEOBJECT Returns a reference after creating a new ActiveX or OLE object (Variant).
CSNG Returns the expression converted to a single data type (Single).
CSTR Returns the expression converted to a string data type (String).
CURDIR Returns the current path of a given drive (Variant / String).
CVAR Returns the expression converted to a variant data type (Variant).
CVDATE Returns the expression converted to a variant date subtype (Variant).
CVERR Returns a specific type of error (Variant).
DATE - Function Returns the current system date (Variant / Date).
DATE - Statement Defines the current system date.
DATEADD Returns the date with a specified time interval added (Date).
DATEDIFF Returns the number of a given time interval between two specified dates (Long).
DATEPART Returns the specified part of a given date (Variant / Integer).
DATESERIAL Returns the date given a year, month and day (Date).
DATEVALUE Returns the date given a string representation of a date (Date).
DAY Returns the day from a given date (Integer).
DDB Returns the depreciation of an asset in a single period (double or higher declining balance method) (Double).
DELETESETTING Removes (or deletes) a key or section from the registry.
DIR Returns the name of a file or directory matching a pattern or attribute (Variant / String).
DOEVENTS Pauses execution to let the system process other events.
ENVIRON Returns information about the current operating system environment (String).
EOF Returns the value indicating if the end of a file has been reached (Boolean).
EQV The logical equivalence operator.
ERASE Reinitialises the elements of an array.
ERROR - Function Returns the error message corresponding to a given error number (String).
ERROR - Statement (Err.Raise) Generates an error.
EXP Returns the base of natural logarithm raised to a power (Double).
FILEATTR Returns the file mode of the specified open file (Long).
FILECOPY Copies a file from one directory to another.
FILEDATETIME Returns the date and time when a file was created or last modified (Date).
FILELEN Returns the length of a file in bytes (Long).
FILTER Returns an array containing a subset of values that contain a substring (Variant).
FIX Returns the integer portion of a number (data type).
FORMAT Returns the text string of a number or date in a particular format (Variant / String).
FORMATCURRENCY Returns the expression formatted as a currency value (String).
FORMATDATETIME Returns the expression formatted as a date or time (String).
FORMATNUMBER Returns the expression formatted as a number (String).
FORMATPERCENT Returns the expression formatted as a percentage (String).
FREEFILE Returns the next valid free file number (Integer).
FV Returns the future value of a series of equal cash flows at regular intervals (Double).
GET Reads data from a text file into a record.
GETALLSETTINGS Returns the list of key settings and their values from the registry (Variant).
GETATTR Returns the attributes of a given file or directory (Integer).
GETOBJECT Returns the reference to an object provided by an ActiveX component.
GETSETTING Reads from the registry and returns the value or key from the registry (String).
GOTO Transfers control to the subroutine indicated by the line label.
HEX Returns the number converted to hexadecimal (Variant / String).
HOUR Returns the hour from a given time (Integer).
IIF Returns one of two parts, depending on the evaluation of an expression.
IMESTATUS Returns the current Input Method Editor mode of Microsoft Windows (Integer).
IMP The logical implication from two values (Variant).
IMPLEMENTS Specifies an interface or class that can be implemented in a class module.
INPUT - Function Reads a number of characters from a file (Variant / String).
INPUT - Statement Reads data from a file and assigns the data to a list of variables (Long).
INPUTBOX Displays a dialog box allowing the user to enter some information (String).
INSTR Returns the position of a substring within a larger string (Variant / Long).
INSTRREV Returns the position of a substring within a larger string, starting at the end (Long).
INT Returns the integer portion of a number (data type).
IPMT Returns the interest paid in a given period in a series of equal cash flows at regular intervals (Double).
IRR Returns the interest rate for a series of unequal cash flows at regular intervals (implicit reinvestment rate) (Double).
IS Compares two object reference variables.
ISARRAY Returns the value True or False depending if the expression is an array (Boolean).
ISDATE Returns the value True or False depending if the expression is a date (Boolean).
ISEMPTY Returns the value True or False depending if the Variant variable has been initialised (Boolean).
ISERROR Returns the value True or False depending if the expression is an error (Boolean).
ISMISSING Returns the value True or False depending if the optional argument has been passed to a procedure (Boolean).
ISNULL Returns the value True or False depending if the expression contains no data (Boolean).
ISNUMERIC Returns the value True or False depending if the expression is a number (Boolean).
ISOBJECT Returns the value True or False depending if the identifier represents an object (Boolean).
JOIN Returns a text string containing all the elements in an array (String).
KILL Deletes an existing file.
LBOUND Returns the lower limit in a given dimension of an array (Long).
LCASE Returns the text string with all characters converted to lowercase (Variant / String).
LEFT Returns a substring from the left of a string (Variant / String).
LEN Returns the number of characters in a string (Long).
LET Computes a value and assigns it to a new variable.
LIKE The pattern matching operator.
LINE INPUT Reads a single line from a file opened with Sequential access (String).
LOAD Loads an object but doesn't display it.
LOADPICTURE Loads a picture from a file into a Picture or Image control (IPictureDisp).
LOC Returns the current read/write position within an open file (Long).
LOCK Locks access to parts of a file for other processes.
LOF Returns the length or size of an open file, in bytes (Long).
LOG Returns the natural logarithm of a number (Double).
LSET Left aligns a string within a string variable.
LTRIM Returns the text string without leading spaces (Variant / String).
MACID Converts a four character constant to a value that can be used by Dir, Kill, Shell and AppActivate.
MID - Function Returns a substring from the middle, left or right of a string (Variant / String).
MID - Statement Replaces a specified number of characters with characters from another string.
MINUTE Returns the minutes from a given time (Integer).
MIRR Returns the interest rate for a series of unequal cash flows at regular intervals (explicit reinvestment rate) (Double).
MKDIR Creates a new directory.
MOD Returns the remainder after division operator (Integer).
MONTH Returns the month from a given date (Integer).
MONTHNAME Returns the month as a string (String).
MSGBOX Displays a dialog box displaying a message to the user (Integer).