Testing for an integer

  • Thread starter Thread starter NH
  • Start date Start date
N

NH

What is the simplest and most effective way of testing whether or not a
number is infact an integer or not.

Is there a built-in function?

In Excel I would compare it to the Floor() of itself, but I am not sure with
Access...

Thanks

Nick
 
What is the simplest and most effective way of testing whether or not a
number is infact an integer or not.
Click to expand...

The answer turns on what *you* mean by "is in fact an integer".

Is a Long Integer an integer? Is the Double value 32.0 an integer?
Is the string "32" an integer? You might want to look at help for the
functions VarType(), TypeName(), and Int().
 
Back
Top