Glitch with Decimal Data Type in Form View

[anonymous]

When editing a decimal data type with 2 decimal places, after you enter, say 3.44, then hover over it while still editing you will see “Please enter a valid value. The two nearest valid values are 3 and 4.”, even though 3.44 is a valid value.

[Steve]

Can you provide a screenshot showing the hover-over message? I’ve never heard of such a thing.

[Marc_Dillon]

>>“Please enter a valid value. The two nearest valid values are 3 and 4.”

That sounds like a custom error message, where someone is using valid_if to force integer values into a decimal column. Check that column’s valid_if, and its “invalid value error” setting.