Access: IsNumeric Function
In Access, the IsNumeric function returns TRUE if the expression is a valid number. Otherwise, it returns FALSE.
The syntax for the IsNumeric function is:
IsNumeric ( expression )
expression is a variant.
For example:
IsNumeric (786) would return TRUE IsNumeric ("Tech on the Net") would return FALSE IsNumeric ("234") would return TRUE
VBA Code
The IsNumeric function can be used in VBA code. For example:
Dim LValue As Boolean
LValue = IsNumeric("Tech on the Net")
In this example, the variable called LValue would contain FALSE as a value.
SQL/Queries
You can also use the IsNumeric function in a query.
