Curious behavior of an if statement

[bknight]

I was running a for loop and had this if statement in it
For I = 1 to Rs!NumRec
iI Fld1 <> I then
Rs.Edit
Fld1=I
rs.Update
next I
There are a couple of other lines in the code but none are pertinent to my question
Fld1 contains essentially the Dbs number from 1 to Recordset.
I import records from Excel and there are no numbers in the spreadsheet.
So when the routine encounters the new records that field(Fld1) is Null.
The routine skipped over the new records not updating Fld11 to I. Now a Null does not equal to any number, so why did it skip over the new records?
I Changed the If statement to If IsNull(Fld1) Then, everything ran well.

[HansV]

Null is not a value like 0 or 1. It is the absence of a value. For this reason, you cannot compare Null to a value

Null = 0 evaluates to Null, not to True (nor to False)
Null > 0 evaluates to Null
Null < 0 evaluates to Null
Null <> 0 evaluates to Null
Null = Null evaluates to Null
Null <> Null evaluates to Null

So you must use IsNull(expression), or in SQL expression Is Null to test for Null.

[bknight]

Ok.