Dolphin.com.bd

Office Suite Tutorial => Microsoft Office Access => Topic started by: bbasujon on August 15, 2012, 05:18:55 PM

Title: Microsoft Access Function Library: IsNumeric()
Post by: bbasujon on August 15, 2012, 05:18:55 PM
Function: IsNumeric()

Purpose: The IsNumeric function returns a value of true if the referenced variable can be evaluated as a number. Otherwise, it returns false.

Usage: IsNumeric(variable_name)

Where variable_name is the name of the variable you wish to test.

Returns: True if the referenced variable can be evaluated as a number; False otherwise.

Example

Dim TestEmpty
TestInt = Int(1)
TestQuote = "Test"
TestDec = 123.45

IsNumeric(TestInt) returns True
IsNumeric(TestQuote) returns False
IsNumeric(TestDec) returns True