Last updated: August 25, 2026.
The Access Mid function returns characters from the middle of a string. Character positions start at 1.
Syntax
Mid(string, start [, length])| Argument | Description |
|---|---|
string | Required source expression. |
start | Required 1-based position of the first character. |
length | Optional number of characters. If omitted, Access returns the rest of the string. |
Examples
Mid("WebCheatSheet", 4, 5) ' Cheat
Mid("INV-2026-0042", 5, 4) ' 2026
Mid([ProductCode], 3) ' From character 3 onwardIf start is greater than the string length, the result is an empty string. A Null source produces Null, so use Nz() when an empty string is the intended fallback.
