validation rule

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

Guest

Hey guys

I'm clueless. I'm trying to create an 'employee ID' field that will only allow users to enter a 7 digit number between 1000000 and 2999999. Anybody know where I can find a quick, easy way to enforce something like this? Or, can anybody send me the code I would need to enforce this? Thanks a million

Mike H
 
1. Open your table in design view.

2. Select the Employee ID field.

3. In the lower pane, set the Validation Rule property to:
Between 1000000 And 2999999

Presumably this is a Number field, with size set to Long Integer.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Mike H said:
I'm clueless. I'm trying to create an 'employee ID' field that will only
Click to expand...
allow users to enter a 7 digit number between 1000000 and 2999999. Anybody
know where I can find a quick, easy way to enforce something like this? Or,
can anybody send me the code I would need to enforce this? Thanks a million,
 
Back
Top