[AccessD] Continuous Forms - Changing Text Colour Of SingleRecord

Ahhhhhh, that's it...thanks very much...I owe a lot to this list... 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: 05 December 2005 11:39
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Continuous Forms - Changing Text Colour Of
SingleRecord

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


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com