Space
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 " ".
FORM
In a Form you could set the Default Value of a Textbox to
=SPACE(5)
VBA
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)
End Sub
Course
Want to learn more? Request this via the contact form.
Search
You can find more about this by searching the website.
By: Alex Hedley
Click here to sign up for more FREE tips
|