IsNumeric
Using the ISNUMERIC Function
In this tutorial you will learn how to use the IsNumeric Function.
The IsNumeric function returns a Boolean value indicating whether an expression can be evaluated as a number.
=IsNumeric( expression )
expression a valid number or number representation
In this example we will use the number 1.
The result is -1 or TRUE.
 Query
The results using a Query would be
SELECT IsNumeric(1);
 FORM
In a Form you could set the Default Value of a Textbox to
=IsNumeric(1)
 VBA
In a Form add a TEXTBOX control and rename it "txtIsNumeric", then you could add the following in the Load Event.
Private Sub Form_Load()
txtIsNumeric = IsNumeric(1)
End Sub
Courses
Access Expert 25
 Search
You can find more about this by searching the website.
By: Alex Hedley
Click here to sign up for more FREE tips
| 
