Test for whole number

Jedster · Oct 14, 2004

Hi,

Can anyone tell me what function I can use to test whether a number is whole?

Thanks in advance.

Jedster

Van T. Dinh · Oct 14, 2004

If Int(YourNumber) = YourNumber Then
' It is a whole number

Michel Walsh · Oct 14, 2004

Hi,

CBool( int(x)=x )

Hoping it may help,
Vanderghast, Access MVP