Last updated: August 26, 2026.
The Right function returns a requested number of characters from the end of a string.
Syntax
Right(string, length)| Argument | Description |
|---|---|
string | Source text |
length | Number of characters to return |
Examples
Right("INV-2026", 4) ' 2026
Suffix: Right([ProductCode], 3)
LastInitial: Right(Trim([LastName]), 1)A negative length raises an error. If length exceeds the string length, the whole string is returned; Null input returns Null.
See Microsoft’s Access function reference for related expression functions.
