[AccessD] Continuous Forms - Changing Text Colour Of Single Record

On 5 Dec 2005 at 10:53, Paul Hartland (ISHARP) wrote:

>  To all,
> 
> I have a continuous form with a check box and a text box with about 100
> (currently) lines of data.  When a user checks the check box I need the
> forecolor of the corresponding text box the change to red.  I tried this by
> something like me.TextBox.ForeColor = 255 and when you check the check box
> every line changes to red.  Is there anyway to only change the color of the
> current record....
> 

Click on the textbox, select Tools-Conditional Formatting"
Set Condition 1 - "Expression is"  - "ChkBox1 = True" and set the forecolor 
for the Preview textbox.





-- 
Stuart