Last updated: August 26, 2026.
The Space function returns a string containing a specified number of spaces.
Syntax
Space(number)| Argument | Description |
|---|---|
number | Number of spaces to return |
Examples
"A" & Space(4) & "B"
Indented: Space(2) & [Label]
FixedWidth: [Code] & Space(10 - Len([Code]))The number must be non-negative. For reports and forms, use layout controls instead of spaces when visual alignment matters.
See Microsoft’s Access function reference for related expression functions.
