Check if a number is an integer.

  • Thread starter Thread starter Doug
  • Start date Start date
D

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.
 
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


Steve Schapel said:
Doug,

[YourNumber]=Int([YourNumber])

--
Steve Schapel, Microsoft Access MVP


Doug said:
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.
Click to expand...
Click to expand...
 
Back
Top