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