Results 1 to 2 of 2
  1. #1
    Merf is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2013
    Posts
    1

    Record-Level Validation in Tables

    OK, I am a total newbie using Access, so this might be a really stupid question, but here goes:
    I am trying to set up record-level validation in a table, to ensure that values in my MailingAddress field do not equal those in my PhysicalAddress field. (If someone's mailing address and physical address are the same, I want the user to leave the PhysicalAddress field blank. Only want to populate PhysicalAddress in cases where, for example, MailingAddress = "PO Box 123" and PhysicalAddress = "671 Main St")
    The Access help information (using Access 2007) says you can enter field-level validation rules (which cannot reference other fields), and/or record-level validation rules (which can refer to multiple fields within a record). Entering a field-level rule seems simple enough, but how do I enter a record-level validation rule?!? The Help says to open the table in Design View, then click on the General tab and enter the rule. But whenever I open my table in Design View, one of the fields is ALWAYS selected! Thus, I am ALWAYS entering a field-level validation rule (and if I try to enter a rule like "[MailingAddress]<>[PhysicalAddress]" it gives me an error message when I try to save it!).



    So, how do you enter a RECORD-level validation rule for a table?

  2. #2
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Personally, I have never used field/record-level validation in a table. I do set a default value on a field once in a great while.

    All of the validation I do is done at the form level; there is much better control over the validation.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Table Level Validation
    By Stretch2312 in forum Access
    Replies: 4
    Last Post: 11-23-2012, 03:17 PM
  2. Validation at form level
    By Kris in forum Forms
    Replies: 1
    Last Post: 06-28-2011, 06:48 AM
  3. BUG! Field level date validation
    By buj in forum Forms
    Replies: 0
    Last Post: 09-16-2010, 08:23 PM
  4. Apply check at record level
    By wasim_sono in forum Programming
    Replies: 1
    Last Post: 04-19-2007, 07:48 AM
  5. Field Level Date validation
    By fadone in forum Forms
    Replies: 1
    Last Post: 12-09-2005, 10:23 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums