Space

Return a number of spaces.

Syntax
      Space(Number)

Key
   Number  The number of spaces to return.

The Space() function may be used in VBA or in an SQL query.

Example

Dim strDemo as String
strDemo = Space(5)

'Returns: "     "

“Empty pockets never held anyone back. Only empty heads and empty hearts can do that” ~ Norman Vincent Peale

Related:

RTrim - Remove trailing spaces from a string.


© Copyright SS64.com 1999-2013
Some rights reserved