Check if a number is an integer.

[Doug]

I'm sure that this is a simple question.

I need to check if a returned value is an integer.

I have converted a date into a number and then divided that number by 8.

I am changing the font colour of a Command button on a calendar (for a
roster) based on if the returned number is an integer.

Hope someone can help.

 

[Steve Schapel]

Doug,

[YourNumber]=Int([YourNumber])

 

[Doug]

Thanks Steve

I knew it would be easier than my solution that I came up with after a few
beers.
Check = CInt([My Number])
If [My Number] - Check = 0 then

I really should drink more

Cheers

Doug,

[YourNumber]=Int([YourNumber])

--
Steve Schapel, Microsoft Access MVP

I'm sure that this is a simple question.

I need to check if a returned value is an integer.

I have converted a date into a number and then divided that number by 8.

I am changing the font colour of a Command button on a calendar (for a
roster) based on if the returned number is an integer.

Hope someone can help.