MS Access Space() Function

Posted by

MS Access

Space()

Function

Example

Return a string with 5 spaces:

SELECT
Space(5) AS SpaceString;


Definition and Usage

The Space() function returns a string of the specified number of space characters.

Syntax

Space(

number

)

Parameter Values

Parameter Description

number
Required. The number of spaces to be returned

Technical Details

Works in: From Access 2000