Check if SQL field item is Null

[mikeymay]

I tried to use

If rs.Fields.Item(intFields) = Null Then

to check if a field in a record is 'Null' but the it doesn't seem to recognise the 'Null' value in the record and returns the code as false.

Is there another way of checking this?

 

[mikeymay]

If IsNull(rs.Fields.Item(intFields)) Then

sOLVED!!!