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

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.
 
J

Jamie Collins

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.

--
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access2007,Set up a validation rule for storing 2 hex digits 4
Excel Conditional Formatting 1
Table validation rule - allow only one occurence in a field 2
Data Validation Rule in Table Design 5
Validation rule for Access 2003 2
Validation Rules 2
validation rule for exactly 5 digits, including leading zeros 0
Text Field Validation Rule for Date 1

Top