Space function

Returns a Variant (String) consisting of the specified number of spaces.

Syntax

Space( number )

The required numberargument is the number of spaces you want in the string.

Remarks

The Space function is useful for formatting output and clearing data in fixed-length strings.

Query example

Expression	Results
SELECT Space(5) AS BlankSpace FROM ProductSales GROUP BY Space(5);	Returns a black string with 5 spaces in the column BlankSpace.

VBA example

Note: Examples that follow demonstrate the use of this function in a Visual Basic for Applications (VBA) module. For more information about working with VBA, select Developer Reference in the drop-down list next to Search and enter one or more terms in the search box.

This example uses the Space function to return a string consisting of a specified number of spaces.

Dim MyString
' Returns a string with 10 spaces.
MyString = Space(10)
' Insert 10 spaces between two strings.
MyString = "Hello" & Space(10) & "World"

See Also

String functions and how to use them