[RESOLVED] VB6 Not Null problem

I'm stuck with this one
When I do the test it is not working
When there is nothing in rsCard!Young1,rsCard!Young1 retuns Null it works
When rsCard!Young1 returns somethings like 25 ore "25" it keeps skipping frmCard.txtnr1.Text = rsCard!Young1
what am I doing wrong

Code:

---

              If rsCard!Young1 = Not Null Then
                frmCard.txtnr1.Text = rsCard!Young1
              End If

---

If you are just filling textboxes you can skip the null check and just append and empty string to the results.

Card.txtnr1.Text = rsCard!Young1 & ""

IsNull() function is what you need:

Code:

---

If Not IsNull(rsCard!Young1) Then
    'your code goes here...
End If

---

use IsNull Function

@NRamakrishna:

try reading previous replies before responding... ;)

Thanks guys both answers work