Last updated: August 26, 2026.
The Replace function substitutes occurrences of one substring with another.
Syntax
Replace(expression, find, replace [, start [, count [, compare]]])| Argument | Description |
|---|---|
expression | Source string |
find | Substring to locate |
replace | Replacement text |
start | Optional 1-based starting position |
count | Optional maximum replacements |
compare | Optional comparison mode |
Examples
Replace("2026-08-26", "-", "/")
CleanPhone: Replace([Phone], " ", "")
Replace("One ONE", "one", "1", 1, -1, vbTextCompare)Specify vbTextCompare when matching should ignore case. A Null expression returns Null.
See Microsoft’s Access function reference for related expression functions.
