data validation

M

mahmoud

hello

please i want to insert data validation for a field so that th number is
less or equal to 10
 
K

Kalyan G Reddy MVP (GGK Tech)

Hello

Double click on the field to open the field properties
Click on the datavalidation and click on Add in the Data validation window
Select the field on which you want the datavalidation in the first drop down
Put the Condition in the second and third dropdowns and select the alert
type in the drop down
Click on OK 3 times to save changes
 

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

Top