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

To check for either Null or zero-length string (""), use

    If Len(txtSuppliedProductID & vbNullString) > 0 Then
            WHERE = " AND productID=" & txtSuppliedProductID.Text
        Else
            If Len(cmoSuppliedProductName & vbNullString) > 0 Then
                WHERE = " AND productID=" & cmoSuppliedProductName.Text
            End If
    End If

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"h3llz" <h3llz@[EMAIL PROTECTED]
> wrote in message 
news:F92ED81A-CDD1-4F4B-A905-1E36AB3DCFA9@[EMAIL PROTECTED]
> I've got this code and it is always returning true, even when the field
is
> blank
>    If Not IsNull(txtSuppliedProductID.Text) Then
>            WHERE = " AND productID=" & txtSuppliedProductID.Text
>        Else
>            cmoSuppliedProductName.SetFocus
>            If Not IsNull(cmoSuppliedProductName.Text) Then
>                WHERE = " AND productID=" & cmoSuppliedProductName.Text
>            End If
>    End If
> unless its not null, and is ""
> "BruceM" wrote:
>
>> 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 ...)
>>
>>