Hi,
I have got a query on which I have built a continuos form. The form contains textboxes which values I need to add. Thus, eg. textbox1 holds '1', textbox2 holds '5', so I create a textbox3 that is the sum of both textboxes 1 en 2, resulting in '6'. Now I need to set conditional formatting on the textbox; ie. if the extbox value exceeds a certain threshold, the backcoler property must change.
Code may look like:
If me.textbox3 > threshold
then textbox3.backcolor= RGB(255,0,0)
Else textbox3.backcolor= RGB(0,255,0)
End If
But where do I need to put the code since the query first need to be ended ...
Thank you in advance.
Kind regards,
Bart