Colour Row in Continuous Form in Access 97

[Guest]

I have read and looked at all the answers/wed sites but non have provided an
answer to my problem. I have 3 conditions. For each condition I would like
the text to be set to a colour - Date Only = Black, Surname Only = Red and
Both = Blue. Two colours is simple Mod 2 etc. But for three all I can do is
set a chkbox to True/False and have a text box whos control source is the
chkbox which gives the text box the requiried back color or the correct
colour for the formatted text. The problem then is that I carnt bring to
front the text box that I need to show on that particular row. We work in
Access 2003 and Access 97 which is the problem, our customers on Access 97
see what others on Access 2003 have and want simular. Any ideas as to a work
around ? Thanks

 

[Rick Brandt]

I have read and looked at all the answers/wed sites but non have provided an
answer to my problem. I have 3 conditions. For each condition I would like
the text to be set to a colour - Date Only = Black, Surname Only = Red and
Both = Blue. Two colours is simple Mod 2 etc. But for three all I can do is
set a chkbox to True/False and have a text box whos control source is the
chkbox which gives the text box the requiried back color or the correct
colour for the formatted text. The problem then is that I carnt bring to
front the text box that I need to show on that particular row. We work in
Access 2003 and Access 97 which is the problem, our customers on Access 97
see what others on Access 2003 have and want simular. Any ideas as to a work
around ? Thanks

Make all the TextBoxes have a transparent background. Then it doesn't matter
which one is on top.