Results 1 to 3 of 3

Thread: [RESOLVED] If Else Problems

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Mar 2006
    Posts
    245

    Resolved [RESOLVED] If Else Problems

    Hey guys,
    Im having a slight issue with a returned value not triggering my If statement the way that i would like.

    VB Code:
    1. If ors("") = Null Then
    2. txtTotNon = "0"
    3. Else
    4. txtTotNon = ors("")
    5. End If

    What exactly am i doing wrong that is causing the statement to not make txtTotNon = "0". The initial value comes back as NULL but skips right to the else and causes an error message. Ive tried both "null" and null but both skip over. Any help would be greatly appreciated. thanks.
    tibor

  2. #2
    Addicted Member Screamager's Avatar
    Join Date
    May 2001
    Location
    Dublin, Ireland
    Posts
    174

    Re: If Else Problems

    VB Code:
    1. If IsNull(ors("fieldname").value) then
    2. 'do stuff
    3. else
    4. 'do other stuff
    5. End If
    Computer /nm./: a device designed to speed and automate errors

  3. #3

    Thread Starter
    Addicted Member
    Join Date
    Mar 2006
    Posts
    245

    Re: If Else Problems

    Oh man thank you so much. So simple but yet caused so much headache, lol. thanks.
    tibor

Posting Permissions

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



Click Here to Expand Forum to Full Width