Validations
Apr 27, 2006
hey i need help in form validations
i have to deliver this project by tomorrow and i can't find anything about validations in sites, or what i find is not useful to me.
i need to validate the field size of each field so it pops up a message when it exceeds that limit. what do i have to type in the validation rule ?
also i need to validate the kind of value each field can accept. i want the number fields to accept only numbers and the text fields only text.what do i have to type in the validation rule ?
please answer asap , i'll be very thankful
View Replies
Feb 11, 2005
i know, i know, this is probabley the simplest thing, but my brain seems to have gone on vacation. please help. i have an unbounded textbox on a form. and need to make it required. i don't want the user to be able to leave the textbox (insertation point) before they enter a value. i can get it to prompt user to enter data, but the cursor moves to next control. how do i get the insertation point to stay in textbox.
thanks
View 1 Replies
View Related
Oct 16, 2013
I have a field in my Customers Table that is a Number type (to record the percentage level of interest). In the Validation property I have <=1 And >=0 to shows percentage. However, I would also like the entries into this field to be limited to increments of 10, such as : 0%, 10%, 20% etc; to 100%. How to correct Validation Rule to only allow increments of 10, and also the Validation Rule (<=1 And >=0) required to show percentages?
View 6 Replies
View Related
Jul 18, 2014
I have to assign multiple table validations to my table but they are not even working separately.
1) I have two combo box controls: [Tocolytics] & [multiple_Tocolytics], 3 check boxes and 1 text box.
Rule:
IIf(([Tocolytic?]="Yes" Or [Multiple Tocolytic?]="Yes"),([Indomethacin]=True Or [Nifedipine]=True Or [Nitroglycerin]=True Or Len([Other])>0),"check one of the boxes")
2)Two combo boxes The answers are mutually exclusive. If one is yes then the other must be "No" or "unable to determine"
Rule:
IIf(Oxytocin Infusion - no PPH]="Yes",([Oxytocin Infusion - if PPH]="No" Or [Oxytocin Infusion - if PPH]="Unable to determine"),[Oxytocin Infusion - if PPH]="Yes")
View 14 Replies
View Related