limit number entry into a textbox

[MatthewGrace]

Is there a way to force a textbox to contain a max of 2 digits to the right of a decimal, with a percent sign at the end? Examples: 32.25%, 15.1%, 12% would be accepted, but 11.999% would NOT because you can't type in the third 9.



Importantly, this is not the same as using the format features of a textbox, because that allows you to type in lots of decimals but it only displays a couple.

[alansidman]

In your table, in the the properties for your field set your limitations.

[MatthewGrace]

The Decimal Places field properties doesn't seem to work as evidenced here:



Am I doing something totally wrong? I hope so...

[June7]

Only way I know with a number type field is to use VBA in BeforeUpdate event to validate the input.

Ooops, forgot about Decimal and Percentage types. Never needed them.

[davegri]

I suggest using Decimal and specify scale and precision properties in the table.
Precision is the total number of digits in a number, including left and right of the decimal.
Scale is the number of digits allowed to the right of the decimal.


So 1234567.89 has a precision of 9.
A precision of 4 and scale of 2 would result in a number with a maximun value of 99.99
123456.789 has a scale of 3 and precision of 9.


Percent designations like 125.5% would require precision 4 and scale of 3 (not one) since it is actually stored as 1.255.