Results 1 to 4 of 4

Thread: Validation Rule

  1. #1
    Join Date
    Jan 2016
    Posts
    2

    Unanswered: Validation Rule

    Hi
    I want to set a validation rule in access 2003 for the table field to accept
    zero entries I have used various combinations of :-
    Code:
     >0 or Is Null or >=0 or Is Null
    it accepts the entry but I get an error message when I try to save the table
    incorrect syntax or entry is to complicated
    can you help please

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    You state that you're trying to set 'validation' but you're actually trying to let the Field 'accept' being zero or Null...not the same thing! Not allowing a certain Value would require a validation rule.

    Is this a Number Field?

    Are you trying to do this in the Table's Design View? If so, simply have the Required Property set to No, which I believe is the Default.

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Jan 2016
    Posts
    2

    Validation Rule

    Hi
    Thanks for your post to give the full picture I am using the access 2003 table as a db for data
    displayed in a Visual Basic Project in editing a VB datagrid I need access to be able to accept
    a blank entry i get an error row cannot be located for updating etc.
    The field in the table is a text type and I have set the required to No
    Can you help further please

  4. #4
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Quote Originally Posted by RocketRon View Post
    Hi
    ... I need access to be able to accept
    a blank entry i get an error row cannot be located for updating etc.
    Not sure it applies here but generally speaking you cannot update a linked table unless it contains an Identity column.
    Have a nice day!

Posting Permissions

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