Re: How do i do a notnull statement? (If (IsNotNull(..) Then ...)

In VBA:

If Not IsNull (Me.SomeField) Then
    ' Do something
    Else
      ' Do something else
End If

The Else part may not be needed, depending on the situation.

In the control source of a text box:

=IIf([SomeField] Is Not Null,"Not Null","Null")

In a query:

NewField: IIf([SomeField] Is Not Null,"Not Null","Null")

This will cause "Not Null" or "Null" to appear in the text box or query 
field.  Substitute the actual actions you would have performed.

In all cases use the actual field name.  In the query you can name the
field 
as you choose.  You don't need to use NewField.

"h3llz" <h3llz@[EMAIL PROTECTED]
> wrote in message 
news:7BE40896-C135-47F7-BF35-21BDCD215260@[EMAIL PROTECTED]
> How do i do a notnull statement? (If (IsNotNull(..) Then ...)