Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Burgas, Bulgaria
    Posts
    209
    Thanks
    0
    Thanked 0 Times in 0 Posts

    If Not (Access 2000)

    I want to specify as Not Is Nll not one but one four or five controls, he name of the controls being C3 etc.Whats wrong with my code ?

    If Not IsNull(Me.C3,C4,C5,C6) Then

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: If Not (Access 2000)

    Do you want to test if all of the controls are not null? If so, use

    If Not IsNull(Me.C3) And Not IsNull(Me.C4) And Not IsNull(Me.C5) And Not IsNull(Me.C6) Then

    Or do you want to test if at least one of the controls is not null? If so, use

    If Not IsNull(Me.C3) Or Not IsNull(Me.C4) Or Not IsNull(Me.C5) Or Not IsNull(Me.C6) Then

Posting Permissions

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