423,850 Members | 1,253 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,850 IT Pros & Developers. It's quick & easy.

Limit to even numbers

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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

This discussion thread is closed

Replies have been disabled for this discussion.