How do I use IF x.text="" OR y.text=""

[sunnyboyj]

I have a form with lets say 2 textboxes; textbox x and textbox y

the thing is I want b4ppc to check if in one of them is text typed in (only ok when OR x OR y is typed in, not ok when x AND y are typed in or if nothing is typed in).
I thought i could use:
If x.text="" OR y.text="" Then
Msgbox("Please fill in x or y")
Return
End If
Thanks!
Jorrit

[agraham]

You probably want

If x.text="" AND y.text="" Then

[sunnyboyj]

I would think you are right. It works better. The problem is bigger:
i have more then two lines which can be filled in:
x.text, y.text and z.text
If I use the AND argument
IF x.text="" AND y.text="" AND z.text="" my program will accept only when one is filled in (and that's what I want!), but also if i fill in all three (and that's what I don't want). My problem is therfore: how do I make my program that it will accept only and filled (x or y or z)?

[sunnyboyj]

Maybe I can do something like add the text from x+y+z and compare that with ""?
I think that's they way, but I don't know how to compare them. I tried this but it's not working:

Can I make a new variable and then

compare=x.text+y.text+z.text
if compare ="" then
etc. etc.

[specci48]

Hi sunnyboyj,

if the textboxes have similar names with different numbers like textbox1, textbox2, etc. you can cycle through the textboxes with the control statement.
I add a small example for this. Maybe it's a possible solution for you.


specci48

[Erel]

You could also use:

compare=x.text & y.text & z.text
if compare ="" then ...

& - Concatenation character.

[derez]

It will be very efficient for at least one program of mine if there is a way to group together several controls (mainly textboxes) and perform operations on all of them using one command, for example - change the color of all the textboxes in the group, or like in this thread - check if the text is null.

Of course, using the control method is possible but then I loose the textboxes specific names and programming becomes much more difficult then it is now...

[agraham]

Of course, using the control method is possible but then I loose the textboxes specific names and programming becomes much more difficult then it is now...

You could try putting the control names in an array and reference them as Control(Array(i)).Color

[sunnyboyj]

thanks, great responses!

[derez]

thanks Agraham, I like your solution

I implemented it on a group of 34 controls to change color and fontcolor - very efficient in saving code lines.

I had to use for -next loop with index, I did not succeed in

Control(boxes()).Color = 0,0,0 and got this error : "object does not contain a definition for ToLower "

is it my fault or the compiler's ?