Looping variable or arrays for boolean?

Hi Calvin,

Your code worries me. If you declare those Textboxes as Boolean I'm not sure you can do a text function of Len() on them.

Read:
https://msdn.microsoft.com/en-us/library/ae382yt8.aspx

I think of a Boolean data type as being a 0 or 1. Both have Length of 1. BUT I'm not sure you can treat them like a string of characters. Normally when you Dim a String it saves a spot in memory for that string and the first character or two are the length of the string. In Boolean you don't have that construct. Just a On/Off or Yes/No or True/False, no length.

Have you tried to Dim your TextBoxes as Text and see what happens then?

In the code you list above the DIM statement and "declare them" mean the same thing.

Try your code again after using

Dim blntext1 As String
Dim blntext2 As String
Dim blntext3 As String
Dim blntext4 As String
Dim blntext5 As String

Try this.

Dim blntext(1 To 5) As Boolean

Dim i As Long

    For i = 1 to 5
        If Len(Me.controls("Textbox" & i)) > 0 Then
            blntext(i) = True 
        End If
    Next i

Perhaps

Function blnText(index As Long) As Boolean
    blnText = (0 < Len(Me.Controls("TextBox" & index).Text))
End Function