Sending error message to log reading SQL
I have a scenario in my test where I need to make sure that the field A in a table doesnt save as null. If it does, I want to send an error message to the log. But although, one field is null in my r...
You probably need to use the IsNull function:
If IsNull(acttest.fields("onefieldA").value) Then ...Of you may need to compare with Nothing:
If Not acttest.fields("onefieldA").value Is Nothing Then ...See also: Nothing vs Empty vs Null
