[RESOLVED] VB6 Not Null problem

[hanssnah]

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

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

[MarkT]

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 & ""

[RhinoBull]

IsNull() function is what you need:

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

[NRamakrishna]

use IsNull Function

[RhinoBull]

@NRamakrishna:

try reading previous replies before responding...

[hanssnah]

Thanks guys both answers work