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


ADVERTISEMENT

Textbox Validations

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

Can Have Multiple Validations In One Field

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

Tables :: Multiple Table Validations

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







Copyrights 2005-15 www.BigResource.com, All rights reserved