I have a continuous form looking at data in a table. Each record has two text boxes and two check (tick) boxes.
If one check box is True then I want the text color of that record to be red, if the other is True then the text should be yellow, and if neither are True the colour should be black (default).
Code along the lines of "If checkbox123 = True then Textbox12.forecolor = vbred" is not suitable as that changes all the textboxes in the continous form.
Does anyone have any ideas please?
Telephoto
If one check box is True then I want the text color of that record to be red, if the other is True then the text should be yellow, and if neither are True the colour should be black (default).
Code along the lines of "If checkbox123 = True then Textbox12.forecolor = vbred" is not suitable as that changes all the textboxes in the continous form.
Does anyone have any ideas please?
Telephoto