Limit to even numbers

Caro

Hello,

Is it possible to create a sort of validation rule that will limit the
data entry in a field to even numbers only ?

thaks,
Caro

Feb 23 '06 #1

salad

Caro wrote:

Hello,

Is it possible to create a sort of validation rule that will limit the
data entry in a field to even numbers only ?

thaks,
Caro

? IIF(5 Mod 2 = 0,"True","False")
False
? IIF(4 Mod 2 = 0,"True","False")
True

Feb 23 '06 #2