By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,027 Members | 1,273 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,027 IT Pros & Developers. It's quick & easy.

Dealing with NULL values in a recordset

P: 98
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!MarketPrice) Then....
Dec 6 '06 #1
Share this Question
Share on Google+
3 Replies


ADezii
Expert 5K+
P: 8,669
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!MarketPrice) Then....
'The syntax looks correct from my end.
Dec 6 '06 #2

NeoPa
Expert Mod 15k+
P: 31,615
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.
Dec 6 '06 #3

P: 98
Thanks for the help!
Dec 7 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.