IsError
Using the ISERROR Function
In this tutorial you will learn how to use the IsError Function.
The IsError function returns a Boolean value indicating whether an expression is an error value.
=IsError( expression )
expression a valid value
In this example we will use the number 1.
The result is 0.
 Query
The results using a Query would be
SELECT IsError(1);
 FORM
In a Form you could set the Default Value of a Textbox to
=IsError(1)
 VBA
In a Form add a TEXTBOX control and rename it "txtIsError", then you could add the following in the Load Event.
Private Sub Form_Load()
txtIsError = IsError(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
| 
