Restrict Value in Table

[kikeman]

Hi,

I have a table with a column with a float value. Is it possible to restrict from the table design that this value must not be bigger than 23.5 and in the case that someone try to enter something bigger than 23.5 it would automatically assign 23.5?

Thanks,
kikeman

 

[pbaldy]

You can use a validation rule to stop entries above that, but I don't think you can do the part about automatically assigning 23.5 when they do (at the table level). You'll have to code that, either in the update event of the control or the form.

 

[kikeman]

What should I put in "Validation rule"?

 

[pbaldy]

Try

<=23.5