Check if value is integer

[paulbradley]

How can I check to see if a value entered by a user is an integer. I have tried the Mod function but can't get it working properly.

Thanks.

 

[Eupher]

Are you sure you want to test whether the value is an integer? Wouldn't it be easier to control the user's input by setting the data type at the table level (if the form is bound to a table) and/or specifying a format or input mask?

If testing the data type is what you really want to do, take a look at the VBA help on the following functions:

VarType()
IsNumeric()
Int()
Fix()
CInt()
TypeName()

Maybe you can find something there that will help you.

HTH...

Ken S.