I seem to be having problems with the validator, I have some text fields with properties set to REQUIRED, and yet you csn save the list with them blank. Also, I have 3 fields to store phone numbers. The table field size is 10 VARCHAR. At the properties box, I have EDIT tab set to text box with VALIDATE AS set to US PHONE (One of the pre set choices on the drop down list). I have the VIEW tab set to Phone Number.
In the phone number field, users can enter any number of ANY characters (up to 10), click save, and the database accepts the input and continues on as normal. The only changes that I can account for is that on both the ADD and EDIT events, I set and AFTER RECORd ADDED event to redirect to a different (Confirmation) page. I would assume that the validator would catch the problem BEFORE adding it, so the event would happen AFTER validation. Any suggestions?