Validation rule: only allow a number conataining 3 or 4 digits

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using MS access 2003, I need to set uo a validation rule for a number
field, that will only allow 3 or 4 digits, any other number that is not 3 or
4 digits should be rejected. I would appreciate any help, thank you.
 
I am using MS access 2003, I need to set uo avalidationrule for a number
field, that will only allow 3 or 4 digits, any other number that is not 3 or
4 digits should be rejected. I would appreciate any help, thank you.
Click to expand...

BETWEEN 100 AND 9999

Jamie.

--
 
Thank you, I never realised it was as simple as that, I thought there would
be a special function for that type of thing, anyway thanks.
 
Back
Top