IsNull and <>""

Is there a shorter expression that brings the same result as "IsNull(ctrl.Value) Or Len(Trim(ctrl.Value)) = 0"?

For example:

Code:

---

    If IsNull(ctrl.Value) Or Len(Trim(ctrl.Value)) = 0 Then
        str = "nuthin here"
    End If

    ' equals

    If ???? Then
        str = "nuthin here"
    End If

---

Matt(+)

What about just
If Len(Trim(ctrl.value))<1 then
'nothing here
End if

don't think Trim on Null vlues will work Lord_Rat:confused:

That doesn't work for null values

Len(Trim(Null)) = Null
Null < 1 = Null '<--type mismatch

Admittedly, I didn't try it this time.

Let me give it a whirl.

mattalexx, I think the way u do it is it... :)

What kind of control?

Using a text box, Trim works fine, as in the attached.

I'm running this function for fields in a DAO recordset.

what about

If (IsNull(ctrl.Value)) Or (ctrl.Value) = "") Then
'Nothing is there
End If


That'll work if the data is going to be a text or a number

That's essentially the same as what I proposed in the beginning, isn't it?

Matt(+)

:D

VB Code:

If Len(Value & "") = 0 Then
    'Nuthin there
End If

The definition for Null as it applies to VB is not the same definition for null as it applies to a recordset. IsNull() isn't 100% effective in this case, but the preceeding code hasn't failed me yet.

Waldo: Just for fun, how many times have you answered this one in the furums yet? ;)

Ummm, how many posts do I have?

I'm sorry, but sometimes the simplest problems are the hardest to find answers to.

Thank you very much for your help, Waldo, it is much appreciated.

Matt(+)

I'm just glad I could help.