Space Function

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

Syntax

Space[$]([number])

The required number argument 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.
The Space$ form String values. The Space form returns FixStr values.

Example

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 = "Hi" & Space(10) & "all"

 

See Also

Spc Function, String Function