Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Number Field - Limit

Status
Not open for further replies.

labprof

Technical User
Jan 26, 2006
49
US
Can someone tell me how I can limit a number field to accept only up to 3 digits. In other words I want the field to be able to accept:

example: 1
or
example: 12
or
example: 123

But NOTaccept

example: 1234
or
example: 12345

There is probably a simple method but I am not familiar to set it.

Your help is extremely appreciated.

Labprof
 
Set the validation rule on the field to
Code:
Between -999 And 999
or
Code:
Between 0 And 999
if you want only positive numbers.

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top