Dealing with NULL values in a recordset

[ineedahelp]

Can anyone tell me if this is correct code? I have to deal with an occasional NULL value in MarketPrice. I am cycling through a recordset created by an SQL

If IsNull(rst!Mark etPrice) Then....

[ADezii]

Can anyone tell me if this is correct code? I have to deal with an occasional NULL value in MarketPrice. I am cycling through a recordset created by an SQL

If IsNull(rst!Mark etPrice) Then....

'The syntax looks correct from my end.

[NeoPa]

That's all good.
However, in some circumstances (not all) it's better to use the function Nz() when dealing with fields which may contain Null.

[ineedahelp]

Thanks for the help!