Re: How to limit the digit in number data type field

  • Thread starter Thread starter Steve Schapel
  • Start date Start date
S

Steve Schapel

Field,

In the design view of the table, put this in the Validation Rule
property of the field concerned:
Between 10000000 And 99999999
.... and also enter something appropriate for the Validation Text property.
 
Steve,

i've tried to put " >10000000<99999999 " into the validation rule of the
respective field, but it still cant solve my problem, i still can enter more
than 8digits into the field, did i do anything wrong ?
 
I am not sure of the meaning of >10000000<99999999 and I'm sure Access
wont be able to figure it out either. In fact, I think Access will
interpret this to mean >0
For your intended meaning, it could be written:
=10000000 And <=99999999
Click to expand...
.... but I think you should try my earlier suggestion, which was:
Between 10000000 And 99999999
 
Hello Steve,

Your response of using Between 10000000 And 99999999 worked great for me.Now
i need to know the same thing for 9 digits since i have tried the above by
changing the numbers and quantity but no luck........what would be the above
parameter for nine digits please....users are making mistakes
galore..................Thanks
 
Back
Top