| Type of Validation |
Entry Field |
Validation Performed |
Code to Perform Validation |
| Date |
|
Check and fix date (123101->12/31/2001) |
Check_Date(this,false) |
| Time |
|
Check and fix time (12P -> 12:00 PM) |
'Check_Time(this,false)' |
| Phone: |
|
Check and fix phone
(7032341234->(703)234-1234) |
Check_Phone(this,"(",false) |
| Zip |
|
Check and fix zip code (US and Canada) |
Check_Zip(this,false) |
| Number (required field) |
|
Validate number (no formatting) |
Check_Number(this,"",true) |
| Number (required field) |
|
Validate number in range (currency, commas and 2 decimal
places > 0 |
'Check_NumberRange(this,"$,2",">",0,"","",true)' |
| Number |
|
Validate number in range >= 10 (1 decimal place w/o commas) |
'Check_NumberRange(this,"1",">=",10,"","",false)' |
| Number |
|
Validate number in range <=100 (blank if 0) |
'Check_NumberRange(this,"0","","","<=",100,false)' |
| Number |
|
Validate number in range > 0 and < 100 |
'Check_NumberRange(this,"",">",0,"<",100,false)' |
| Number |
|
Validate number in range > 0 and <= 100 |
'Check_NumberRange(this,"",">",0,"<=",100,false)' |
| Number |
|
Validate number in range >= 10 and <= 100 |
'Check_NumberRange(this,"",">=",10,"<=",100,false)' |
| Text (required field) |
|
Validate data entered in required field |
Check_Required(this) |
| Text |
|
Validate text in range > A and <= CZ |
'Check_Range(this,">","A","<=","CZ",false)' |
|
|
|
|