Input Validation Help. NO DECIMALS

[Chuck712]

Anyone have an idea as to how to stop users from entering fractions, or decimals into a field. I have queries that run against a table that must have whole numbers, no decimal. It is a calculation for years and I want them to round off. I would like to put in a validation rule that will not allow 2.5 year, when it should be just 2 years
Any help?

 

[RickSpr]

Say your text box control is named "txtYears". The following Validation Rule will work:
InStr([txtYears].[Text],".&quot=0 Rick Sprague

 

[allanon]

Put this in the input mask for the field:

0000


Nothing but 4 digits allowed.

 

[Chuck712]

Thanks everyone. That worked.
Chuck