Author Topic: Microsoft Access Function Library: IsNumeric()  (Read 5011 times)

bbasujon

  • Administrator
  • VIP Member
  • *****
  • Posts: 1826
  • I want to show my performance at any where
    • View Profile
    • Higher Education
Microsoft Access Function Library: IsNumeric()
« 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
Acquire the knowledge and share the knowledge so that knowing,learning then sharing - all are the collection