Number Validation Rule - Should be easy !!!

[StevenSkinner]

Hello,

I need to have a validation rule in the Table which basically makes sure the NUMBER they have entered is 8 numeric digit's long (The field is a number field) ??

Any Ideas ????

 

[Andrew Fergus]

Hi
There are a couple of ways of doing this depending on the upper and lower value limits. If the number must be contain at least 8 digits, with the first digit being greater than zero, then use a validation rule of >9999999. However, if you want to allow leading zeroes and there can only ever be 8 digits, then use a input mask of 00000000 instead. But if you want to allow values greater than 99,999,999 then use a format of 00000000 as a last resort.
HTH, Andrew.

 

[StevenSkinner]

That's Great Thank You :wink: