Validating for numbers and null

  • Thread starter Thread starter CSDunn
  • Start date Start date
C

CSDunn

Hello,
How would I set up a Validation Rule to allow for only numbers (up to three
digits) and Null values?

Thanks!

CSDunn
 
How about using an input mask of 000. This will allow only numbers, upto 3
digits, and nulls. No validation needed.

Kelvin
 
Kelvin,
Thanks for your help!

CSDunn

Kelvin said:
How about using an input mask of 000. This will allow only numbers, upto 3
digits, and nulls. No validation needed.

Kelvin
Click to expand...
 
You must log in or register to reply here.

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

Validation Rule Problem 4
Validation Rules for a Control on a Form (?) 4
Limit combo box to list or Null 1
Validation rule involving another control 3
Null and Generic Type 2
Validation Rule Error Messages 1
Access Userform validation rule wont work - Please help 0
If control is null then... 13

Back
Top