MS Access String Functions
MS Access String Functions, with function, and description.
Look inside
Showing 10 of 23 records. Sort the preview by selecting a column heading.
| 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 |
Free sample files (up to 10 rows): CSV JSON XML
Scope and sources
Last changed: July 17, 2026. This may reflect a change to the data or its description; it is not a coverage-through date.
No source links are listed for this dataset. Ask about its coverage before using it where accuracy or recency matters.
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.
Without a pass, sorting and randomization apply only to the fixed 10-row sample.