Technology · Reference dataset
Microsoft Access String Functions
Microsoft Access string functions and descriptions of their uses.
Download options
Every record
All 23 records · Last changed July 17, 2026 · Select a column heading to sort.
| Function | Description |
|---|---|
| Asc | Returns the ASCII value for the specific character |
| Chr | Returns the character for the specified ASCII number code |
| Concat with & | Adds two or more strings together |
| CurDir | Returns the full path for a specified drive |
| Format | Formats a value with the specified format |
| InStr | Gets the position of the first occurrence of a string in another |
| InstrRev | Gets the position of the first occurrence of a string in another, from the end of string |
| LCase | Converts a string to lower-case |
| Left | Extracts a number of characters from a string (starting from left) |
| Len | Returns the length of a string |
| LTrim | Removes leading spaces from a string |
| Mid | Extracts some characters from a string (starting at any position) |
| Replace | Replaces a substring within a string, with another substring, a specified number of times |
| Right | Extracts a number of characters from a string (starting from right) |
| RTrim | Removes trailing spaces from a string |
| Space | Returns a string of the specified number of space characters |
| Split | Splits a string into an array of substrings |
| Str | Returns a number as string |
| StrComp | Compares two strings |
| StrConv | Returns a converted string |
| StrReverse | Reverses a string and returns the result |
| Trim | Removes both leading and trailing spaces from a string |
| UCase | Converts a string to upper-case |
Open this data in a free tool: CSV to JSON · JSON formatter · SQL INSERT generator · CSV to XML
CSV / JSON / XML
Put this data to work.
All 23 records are available without a pass, within the free request limits.
- CSV for spreadsheets and lookup tables
- JSON for apps and data analysis
- XML for imports and integrations
Choose your file
Your key is used for this request and is not saved by this page.
Commercial use is allowed, free or paid.
Downloaded a CSV? Convert CSV to JSON, generate SQL inserts, remove duplicate lines, or sort a list with the free tools.
Scope and sources
Last checked against sources: October 15, 2026.
Last changed: July 17, 2026. This is when we last changed the data or its description. It doesn’t mean the data runs up to that date.
Microsoft Access String Functions has 23 records and 2 fields: Function, Description.
A complete download includes all 23 records currently held in this dataset. Check the description and sources to decide whether its scope fits your project.
Use this dataset through the API
GET https://mysafeinfo.com/api/data/msaccessstringfunctionsChoose a format, sort, or request fewer rows. A pass key gives access to the complete dataset. See the examples and parameters.