By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,934 Members | 1,692 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,934 IT Pros & Developers. It's quick & easy.

Validating number field

P: n/a
hello,

I am new to access .I am trying to validate a numeric field (Employee
number)This field is not auto generated,it is user input field.The
data entered in this field should not be less than or = to 0.Can
anyone tell me how to set the validation rule for this at the design
time.I have given a message for validation.Any other suggestion as to
how best I
can validate this field is welcome.

Thanks
Dos
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Open the table in design view.

Select the field.

In the lower pane, enter this beside Validation Rule:
0
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Brains" <gm****@yahoo.com> wrote in message
news:33**************************@posting.google.c om...
I am new to access .I am trying to validate a numeric field (Employee
number)This field is not auto generated,it is user input field.The
data entered in this field should not be less than or = to 0.Can
anyone tell me how to set the validation rule for this at the design
time.I have given a message for validation.Any other suggestion as to
how best I
can validate this field is welcome.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.