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"
