Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Toledo, Ohio, USA
    Posts
    141
    Thanks
    0
    Thanked 0 Times in 0 Posts

    table/control validation

    Post deleted by jp2558

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: table/control validation

    The rules are additive - if any of them (control, field in a table, or table) fail, then the validation fails. So, no, you don't need to put validation rules on your controls if they are already on the fields of your tables. Quoting from the Access 2000 help (and it also applies to Access 97):

    <hr>Order of validation for controls and fields
    Validation rules for controls and fields are evaluated in the following order:

    Macro or event procedure validation (for example, a macro or an event procedure that responds to the BeforeUpdate event of the control or the form containing the control)


    The control's ValidationRule property


    The underlying table's validation rules for the field (as set in the field's ValidationRule, Required, and AllowZeroLength properties)


    The underlying table's ValidationRule property (this property performs validation on records) <hr>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •