Complete List

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).
NAME	Renames an existing file or directory.
NOT	The logical 'NOT' operator (Boolean).
NOW	Returns the current system date and time (Date).
NPER	Returns the number of periods for an investment (Double).
NPV	Returns the present value of a series of unequal cash flows at regular intervals (Double).
OBJPTR	Returns a LongPtr on a 64 bit version and a Long on a 32 bit version.
OCT	Returns the number converted to octal (Variant / String).
OPEN	Opens a text file or CSV file.
OR	The logical 'OR' operator (Boolean).
PARTITION	Returns a string indicating which particular range it falls into (String).
PMT	Returns the amount of principal and interest paid in a given period in a series of equal cash flows at regular intervals (Double).
PPMT	Returns the amount of principal paid in a given period in a series of equal cash flows at regular intervals (Double).
PRINT	Writes data to a file opened with Sequential access (display-formatted).
PUT	Writes data from a record into a text file.
PV	Returns the present value of a series of equal cash flows at regular intervals (Double).
QBCOLOR	Returns the RGB colour corresponding to the specified colour number (Long).
RAISEEVENT	Fires an event declared at module level within a class, form or document.
RANDOMIZE	Initialises the random number generator.
RATE	Returns the interest rate for a series of equal cash flows at regular intervals (Double).
REDIM	Initialises and resizes a dynamic array.
REM	Specifies a single line of comments.
REPLACE	Returns the text string with a number of characters replaced (String).
RESET	Closes all files open with the Open statement.
RGB	Returns the number representing an RGB colour value (Long).
RIGHT	Returns a substring from the right of a string (Variant / String).
RMDIR	Removes an existing directory.
RND	Returns a random number between 0 and 1 (Single).
ROUND	Returns a number rounded to a given number of decimal places (Double).
RSET	Right aligns a string within a string variable.
RTRIM	Returns the text string without trailing spaces (Variant / String).
SAVEPICTURE	Saves a graphic image from an objects Picture or Image property to a file.
SAVESETTING	Writes to the registry and saves a section or key in the registry.
SECOND	Returns the seconds from a given time (Integer).
SEEK - Function	Returns the current read/write position within a file opened using the Open statement (Long).
SEEK - Statement	Repositions where the next operation in a file will occur.
SENDKEYS	Sends keystrokes to an application.
SET	Assigns an object reference to an object variable.
SETATTR	Defines the attributes of a file or directory.
SGN	Returns the sign of a number (Integer).
SHELL	Returns the program's task id from running an executable programs (Double).
SIN	Returns the sine of an angle in radians (Double).
SLN	Returns the straight-line depreciation of an asset over a single period of time (Double).
SPACE	Returns the specified number of spaces (Variant / String).
SPC	Inserts a specified number (n) of spaces when writing or displaying text.
SPLIT	Returns an array containing a specified number of substrings (Variant).
SQR	Returns the square root of a number (Double).
STOP	Suspends execution.
STR	Returns the text string of a number (Variant / String).
STRCOMP	Returns the result of a string comparison (Variant / Integer).
STRCONV	Returns the text string converted to a specific case or type (Variant / String).
STRING	Returns a repeating character of a given length (Variant / String).
STRPTR	Returns a LongPtr on a 64 bit version and a Long on a 32 bit version.
STRREVERSE	Returns the text string with the characters reversed (Variant / String).
SWITCH	Returns a value based on expressions (Variant).
SYD	Returns the sum-of-years' digits depreciation of an asset (Double).
TAB	Used with the Print # statement or the Print method to position output.
TAN	Returns the tangent of an angle (Double).
TIME - Function	Returns the current system time (Date).
TIME - Statement	Defines the current system time.
TIMER	Returns the number of seconds elapsed since midnight (Single).
TIMESERIAL	Returns the time for a specific hour, minute and second (Date).
TIMEVALUE	Returns the time given a string representation of a time (Date).
TRIM	Returns the text string without leading and trailing spaces (Variant / String).
TYPENAME	Returns the data type of the variable as a string (String).
TYPEOF	Returns the object data type.
UBOUND	Returns the upper limit in a given dimension of an array (Long).
UCASE	Returns the text string with all the characters converted to uppercase (Variant / String).
UNLOAD	Removes an object from memory.
UNLOCK	Controls access to a file.
VAL	Returns the first number contained in a string (Double).
VARPTR	Returns a LongPtr on a 64 bit version and a Long on a 32 bit version.
VARTYPE	Returns the number indicating the data type of a variable (Integer).
WEEKDAY	Returns the number representing the day of the week for a given date (Integer).
WEEKDAYNAME	Returns the day of the week as a string (String).
WIDTH	Assigns an output line width (characters) for the open file.
WRITE	Writes data to a file opened with Sequential access.
XOR	The logical exclusion operator.
YEAR	Returns the year from a date (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).
NAME Renames an existing file or directory.
NOT The logical 'NOT' operator (Boolean).
NOW Returns the current system date and time (Date).
NPER Returns the number of periods for an investment (Double).
NPV Returns the present value of a series of unequal cash flows at regular intervals (Double).
OBJPTR Returns a LongPtr on a 64 bit version and a Long on a 32 bit version.
OCT Returns the number converted to octal (Variant / String).
OPEN Opens a text file or CSV file.
OR The logical 'OR' operator (Boolean).
PARTITION Returns a string indicating which particular range it falls into (String).
PMT Returns the amount of principal and interest paid in a given period in a series of equal cash flows at regular intervals (Double).
PPMT Returns the amount of principal paid in a given period in a series of equal cash flows at regular intervals (Double).
PRINT Writes data to a file opened with Sequential access (display-formatted).
PUT Writes data from a record into a text file.
PV Returns the present value of a series of equal cash flows at regular intervals (Double).
QBCOLOR Returns the RGB colour corresponding to the specified colour number (Long).
RAISEEVENT Fires an event declared at module level within a class, form or document.
RANDOMIZE Initialises the random number generator.
RATE Returns the interest rate for a series of equal cash flows at regular intervals (Double).
REDIM Initialises and resizes a dynamic array.
REM Specifies a single line of comments.
REPLACE Returns the text string with a number of characters replaced (String).
RESET Closes all files open with the Open statement.
RGB Returns the number representing an RGB colour value (Long).
RIGHT Returns a substring from the right of a string (Variant / String).
RMDIR Removes an existing directory.
RND Returns a random number between 0 and 1 (Single).
ROUND Returns a number rounded to a given number of decimal places (Double).
RSET Right aligns a string within a string variable.
RTRIM Returns the text string without trailing spaces (Variant / String).
SAVEPICTURE Saves a graphic image from an objects Picture or Image property to a file.
SAVESETTING Writes to the registry and saves a section or key in the registry.
SECOND Returns the seconds from a given time (Integer).
SEEK - Function Returns the current read/write position within a file opened using the Open statement (Long).
SEEK - Statement Repositions where the next operation in a file will occur.
SENDKEYS Sends keystrokes to an application.
SET Assigns an object reference to an object variable.
SETATTR Defines the attributes of a file or directory.
SGN Returns the sign of a number (Integer).
SHELL Returns the program's task id from running an executable programs (Double).
SIN Returns the sine of an angle in radians (Double).
SLN Returns the straight-line depreciation of an asset over a single period of time (Double).
SPACE Returns the specified number of spaces (Variant / String).
SPC Inserts a specified number (n) of spaces when writing or displaying text.
SPLIT Returns an array containing a specified number of substrings (Variant).
SQR Returns the square root of a number (Double).
STOP Suspends execution.
STR Returns the text string of a number (Variant / String).
STRCOMP Returns the result of a string comparison (Variant / Integer).
STRCONV Returns the text string converted to a specific case or type (Variant / String).
STRING Returns a repeating character of a given length (Variant / String).
STRPTR Returns a LongPtr on a 64 bit version and a Long on a 32 bit version.
STRREVERSE Returns the text string with the characters reversed (Variant / String).
SWITCH Returns a value based on expressions (Variant).
SYD Returns the sum-of-years' digits depreciation of an asset (Double).
TAB Used with the Print # statement or the Print method to position output.
TAN Returns the tangent of an angle (Double).
TIME - Function Returns the current system time (Date).
TIME - Statement Defines the current system time.
TIMER Returns the number of seconds elapsed since midnight (Single).
TIMESERIAL Returns the time for a specific hour, minute and second (Date).
TIMEVALUE Returns the time given a string representation of a time (Date).
TRIM Returns the text string without leading and trailing spaces (Variant / String).
TYPENAME Returns the data type of the variable as a string (String).
TYPEOF Returns the object data type.
UBOUND Returns the upper limit in a given dimension of an array (Long).
UCASE Returns the text string with all the characters converted to uppercase (Variant / String).
UNLOAD Removes an object from memory.
UNLOCK Controls access to a file.
VAL Returns the first number contained in a string (Double).
VARPTR Returns a LongPtr on a 64 bit version and a Long on a 32 bit version.
VARTYPE Returns the number indicating the data type of a variable (Integer).
WEEKDAY Returns the number representing the day of the week for a given date (Integer).
WEEKDAYNAME Returns the day of the week as a string (String).
WIDTH Assigns an output line width (characters) for the open file.
WRITE Writes data to a file opened with Sequential access.
XOR The logical exclusion operator.
YEAR Returns the year from a date (Integer).