Access: Space Function
In Access, the Space function returns a string with a specified number of spaces.
The syntax for the Space function is:
Space ( number )
number is the number of spaces to be returned.
For example:
Space (3) would return " " Space (7) would return " "
VBA Code
The Space function can be used in VBA code. For example:
Dim LResult As String
LResult = Space (5)
In this example, the variable called LResult would now contain the value " ".
SQL/Queries
You can also use the Space function in a query.
