Hi Guys,

In VB.NET is there a

SQL IsNull(value,valueifNull) or
Access NZ Type Function

ie if an object or a string value is null you can give it a default value using a function
eg
If IsNull(me.txtname.text,"Blank") = "Blank" Then
msgbox "Please enter name"
end if

Thanks
Rag