If IsNull Statement

[Secret Squirrel]

I'm trying to write an "If" statement using the "IsNull" function but I'm
stuck on how to write this. What I'm trying to do is write this code to say
if a field is blank do nothing and if a field has data then do the
"SendObject" function. This is being put in the "AfterUpdate" event on a
certain field.

 

[SusanV]

If IsNull([YourField] Then
'do something
else
'do something else
end if

 

[Secret Squirrel]

Hi Susan,

I understand that part but if I only want to do something if there is data
how do I write that? If it's null then I don't want it to do anything. Only
if it's not null.

If IsNull([YourField] Then
'do something
else
'do something else
end if
--
hth,
SusanV

I'm trying to write an "If" statement using the "IsNull" function but I'm
stuck on how to write this. What I'm trying to do is write this code to
say
if a field is blank do nothing and if a field has data then do the
"SendObject" function. This is being put in the "AfterUpdate" event on a
certain field.