Hello,
I have a form and a lot of text boxes on it.
I want to change the color of the text box when the value is entered.
So, i know how to do that using conditional formating.
Also, i know how to that using after update event.....
My question is: Is it posible create a loop and check all text box on the form. If no value, back color = white, if value is there, back color = red, for example.
Something like:
And where i need put that code ?
On the form current property ?
Any idea ?
I have a form and a lot of text boxes on it.
I want to change the color of the text box when the value is entered.
So, i know how to do that using conditional formating.
Also, i know how to that using after update event.....
My question is: Is it posible create a loop and check all text box on the form. If no value, back color = white, if value is there, back color = red, for example.
Something like:
Code:
Dim ctl As Control
For Each ctl In Forms!Form1.Controls
If ctl.ControlType = acTextBox .....
And where i need put that code ?
On the form current property ?
Any idea ?