Re: Strings & Textboxes!!
Try something like:
If len(Text1) then
'There's Something in Text1
else
'There's nothing in Text1
End If
If you're going to be checking 20 or so Textboxes, it may be wise to create a Control Array by setting the Index Property of Text1 to Zero and Creating 19 other Textboxes called Text1 with Indexes from 1 To 19, then you can use the Same Code to Check all the Textboxes, ie.
for iIndex = 0 to 19
If len(Text1(iIndex)) then
Msgbox "Textbox " & iIndex & " Has Something In It"
End If
next
Aaron Young
Analyst Programmer
[email protected]
[email protected]