MySafeInfo

MS Access String Functions

Technology 23 records updated 2026-07-17

MS Access String Functions, with function, and description.

Get this data

GET https://mysafeinfo.com/api/data/msaccessstringfunctions

JSON XML CSV Download CSV

Sort, page, randomize, and download with query parameters; see the documentation.

Try it live

Run a request against msaccessstringfunctions straight from your browser. Add your API key to lift the row cap and return every record. The call goes to the API and nothing is stored here.

Preview

First 23 of 23 records. Click a column to sort these rows.

ID Function Description
1 Asc Returns the ASCII value for the specific character
2 Chr Returns the character for the specified ASCII number code
3 Concat with & Adds two or more strings together
4 CurDir Returns the full path for a specified drive
5 Format Formats a value with the specified format
6 InStr Gets the position of the first occurrence of a string in another
7 InstrRev Gets the position of the first occurrence of a string in another, from the end of string
8 LCase Converts a string to lower-case
9 Left Extracts a number of characters from a string (starting from left)
10 Len Returns the length of a string
11 LTrim Removes leading spaces from a string
12 Mid Extracts some characters from a string (starting at any position)
13 Replace Replaces a substring within a string, with another substring, a specified number of times
14 Right Extracts a number of characters from a string (starting from right)
15 RTrim Removes trailing spaces from a string
16 Space Returns a string of the specified number of space characters
17 Split Splits a string into an array of substrings
18 Str Returns a number as string
19 StrComp Compares two strings
20 StrConv Returns a converted string
21 StrReverse Reverses a string and returns the result
22 Trim Removes both leading and trailing spaces from a string
23 UCase Converts a string to upper-case

Notes