Saturday, June 18, 2022

Space Function [MS]

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"

String functions and how to use them

No comments:

Post a Comment

Search This Blog

Type in a bi-directional language in Office for iPad or iPhone (iOS 8) [MS]

Type in a bi-directional language in Office for iPad or iPhone (iOS 8) Ex...