Invalid use of NULL (?!!)

[mikewood1980]

Hi

Can anyone help me with this - I keep getting an error on the line marked *** "Invalid use of NULL". The only way that the code can reach this line is if rsWallCons("intLeafID2").Value is NOT null - how is this possible?!!?

If rsWallCons("intLeafID2").Value = Null Then
                    MsgBox ("we dont have a wall")
                    intLeafID2 = 0
                Else
                    intLeafID2 = rsWallCons("intLeafID2").Value ***
                    
                End If

Can anyone help?

Thanks
Mike

 

[ErikSnoek]

Hm, try

intLeafID2 = nz(rsWallCons("intLeafID2").Value,0)

 

[namliam]

You cannot do... rsWallCons("intLeafID2").Value = Null

The proper If condition would be Isnull(rsWallCons("intLeafID2").Value)

Greets

 

[mikewood1980]

You cannot do... rsWallCons("intLeafID2").Value = Null

The proper If condition would be Isnull(rsWallCons("intLeafID2").Value)

Greets

Thats great - thanks guys - I tried namliam's idea first and that worked!