Null value ?

[RpbertS]

is there anyway in code to check for a null value in a field and if there is one change the value?

I can handle changin the value =) but am not sure what the syntax is or how to reference a null value...if that makes sense.

well thanks for the time,
Rpb

 

[nick]

simply use the isnull function eg.

if isnull([fieldname) then
open a recordset
change the value
endif

[This message has been edited by nick (edited 04-14-2000).]