Change font color from a check box

[Guest]

I have a situation on a continuous form that I created. Each form is being
displayed as an individual row. I have placed a check box on the form. When
the check box is selected I want the font color of a text box to changes from
black to red. The problem is the font color changes all the forms in view. I
need the font color change just for one individual row/ form. Note the
database is created for Access 97

 

[Marshall Barton]

I have a situation on a continuous form that I created. Each form is being
displayed as an individual row. I have placed a check box on the form. When
the check box is selected I want the font color of a text box to changes from
black to red. The problem is the font color changes all the forms in view. I
need the font color change just for one individual row/ form. Note the
database is created for Access 97

This a fairly easy in version after A97 using Conditional
Formatting.

In A97 and earlier, you need to use an extra text box behind
the one you want to highlight.

First, set your text box's BackColor to the highlight color,
then set its BackStyle to Transparent.

Download and install the LaBox font from
http://www.mvps.org/access/forms/frm0055.htm

Next, create a new text box with normal BackStyle and
BackColor. Set its ForeColor to the highlight color of your
choice and its Font to the LaBox font. Use a control source
expression something like:
=IIf(thecheckbox, "AAAAAAAAAAAA", Null)
and adjust the FontSize to a large enough size to fill the
text box.

Then size and position this new text box so it is the same
size and in same place as your text box. Finally, use
Format - Send to Back to put it behind your text box.