Str
Using the STR Function
In this tutorial you will learn how to use the STR Function.
The STR function returns a String representation of a number.
=STR( number )
number a valid Integer.
In this example we will work with the number 12.
The result is "12".
FORM
In a Form you could set the Default Value of a Textbox to
=STR(12)
VBA
In a Form add a TEXTBOX control and rename it "txtStr", then you could add the following in the Load Event.
Private Sub Form_Load()
txtStr = Str(12)
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
|