Colour Rows on a Continuous Form in Access 97

[Kaz G]

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

 

[Allen Browne]

The only formatting you can give on a continuous form in versions older than
A2000 is the 3 numeric formats. If a control evaluates to postive, negative,
or zero, you can specify a color for *this* control in its Format property,
and the ForeColor changes.

I've used that to effect by placing a text box on the form, bound to a
numeric expression, and showing a character (wingding?) that changes and
changes color based on the 3 possible states of the expression. Although it
is not changing the BackColor or the color of the actual control, it does
act as a visual flag for the row quite successfully. From memory, the A97
Help file does provide examples under Format.

For anything more than that, you would need to pass the responsibility back
to the client to upgrade if the feature is important to them.