Limit Number field - HELP

[Adam]

I'm trying to limit input into a field on a form who underlying table field
format is a number field formatted "general number" and field size is
"double" - I only want the user to be able to enter a max of 2 digits in the
field, can this be done??

 

[Beetle]

You can put a validation rule in the table field of;

Between 1 And 99

If you want to allow null in the field then it would be;

IsNull Or Between 1 And 99

 

[John W. Vinson]

I'm trying to limit input into a field on a form who underlying table field
format is a number field formatted "general number" and field size is
"double" - I only want the user to be able to enter a max of 2 digits in the
field, can this be done??

Ummmm... why pick a datatype which allows 14 digits of precision and a range
from 10^-300 to 10^300 - if all you want is a two digit integer!?

You can use an Input Mask of "90" to force entry of one or two digits; or use
the BeforeUpdate event of the field to check the entry for allowed values and
cancel the update if it's out of range.