Dear Professionals,

I'd like to restrict certain field so that the user can enter only a certain decimal number.

I only want the users to enter:

1.5,2.5,3.5 and so on. Only x.5

But not:

1.1,2.4,3.7 and so on.

I've tried the Round() function at Auto Enter Calculated Value,

but did not work.

I'd really appreciate if someone can help me out.

Edited February 17, 200916 yr by Guest

X - Int(X) = 0.5

Use this as a "validate by calculation"

I've tried the Round() function at Auto Enter Calculated Value,

but did not work.

something like this may work.

Round ( X / 5 ; 1 ) * 5

Assuming integers are allowed as well, try validating the field by calculation =

not Mod ( 2 * YourField ; 1 )

Thank you all!

raybaudi's calculation best fitted my need this time.

I should have payed more attention in my Math class...