Using the SPACE Function
In this tutorial you will learn how to use the SPACE Function.
The SPACE function returns a String with a specified number of spaces.
=SPACE( number )
number a valid Integer.
In this example we will work with the number 5.
The result is " ".
In a Form you could set the Default Value of a Textbox to
In a Form add a TEXTBOX control and rename it "txtSpace", then you could add the following in the Load Event.
Private Sub Form_Load()
txtSpace = Space(5)
Want to learn more? Request this via the contact form.
You can find more about this by searching the website.
By: Alex Hedley
Click here to sign up for more FREE tips