Referring to Value of Text Box

[fredk]

I have about 25 text boxes that hold values - both positive and negative - If I want to have each of the 25 reviewed and the text color changed to red or black depending on the value, I thought I could use a for next statement to run through all the controls - My question is how do I refer to the value of the variable in my code.

In other words, if I only needed to look at one value I would use If [text1] < 0 - When I am using a variable how do I refer to the value of the variable?

Thanks for the assistance!!!

 

[BlackKnight]

Hi,

You could use:

Dim Ctl As Control

For Each Ctl In Me.Controls
If TypeOf Ctl Is TextBox Then
Ctl.ForeColor = IIf(Ctl < 0, vbRed, vbBlack)
End If
Next Ctl
Set Ctl = Nothing

Have a good one!
BK

 

[fredk]

Thanks for your help BK - I really appreciate it!!!!!

Fred