Validation Rule

[rishimittal]

hi i am new to access but i am trying my hands on it...

i have a problem:
i want to put some validation rule(constraints) on a field in the table such that user can only able to enter only 10 digit number and even if that number starts form "0" then it shows the starting zeros without concatenation.
for ex if user put 0681482803 then it should not convert back to 681482803

also one more thing i want to ask what is the best Field size for 10 digit number.. as long integer doesn't fulfill the requirement and double is very large

 

[ivi77]

If you want the 0 to show up before the number, make the field as Text instead of Number and have an input mask for 10 digits so that the user is bound to enter all 10 digits or nothing

 

[rishimittal]

but then i would have problem accessing this field as numeric...
also you have not answered my first problem that how to input exactly 10 digit number...

 

[ivi77]

If you make a field to have an input mask for 10 digits, a user cannot enter anything more or less than 10 characters... And to access the field as numeric, use the VAL function