Y Yecats131 Registered User. Local time Yesterday, 18:43 Joined Apr 22, 2008 Messages 63 Apr 23, 2008 #1 Hello, I need to write an if statement to base its action on if the character length is > 0 . I cannot figure out how to do this, as the length property doesn't seem to exsist. Any ideas? Thanks!
Hello, I need to write an if statement to base its action on if the character length is > 0 . I cannot figure out how to do this, as the length property doesn't seem to exsist. Any ideas? Thanks!
pbaldy Wino Moderator Staff member Local time Yesterday, 18:43 Joined Aug 30, 2003 Messages 36,157 Apr 23, 2008 #2 There is a Len() function that will return the length of a string. To test length and Null: If Len(Me.ControlName & vbNullString) > 0 Then
There is a Len() function that will return the length of a string. To test length and Null: If Len(Me.ControlName & vbNullString) > 0 Then
Y Yecats131 Registered User. Local time Yesterday, 18:43 Joined Apr 22, 2008 Messages 63 Apr 23, 2008 #3 Oh sweet! That worked. Thanks :0) I'm totally teaching myself as I go, if you can't tell. :0)