[AccessD] Continuous Forms Formatting

Boyd, Mark Thomas (US - Philadelphia) mboyd at deloitte.com
Wed Nov 9 15:57:25 CST 2005


Thanks again Stuart.
Another question regarding conditional formatting.  If Checkbox1 is
disabled, is there a way to enable it when ComboBox1 is selected?
Again, I only want to do this with the current record, not all of them.
I tried the conditional formatting option under the Format menu, but
this option is disabled for checkboxes. 

Thanks.

Mark Boyd 
Senior Consultant 
Enterprise Risk Services 
Deloitte & Touche LLP 
  
Tel: +1 215 405 5576
mboyd at deloitte.com 
www.deloitte.com 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
McLachlan
Sent: Wednesday, November 09, 2005 4:25 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Continuous Forms Formatting

On 9 Nov 2005 at 16:12, Boyd, Mark Thomas (US - Phila wrote:

> I need to use conditional formatting on a continuous form.
> This would be easy, but I need to change the color of TextBox1 when
> CheckBox1 is clicked.  The key here is to not change the color for
every
> record on the form, just the selected one.
>  



In Design view:
1.Select TextBox1

2.On the main menu, select  "Format - Conditional formatting..."

3. In Condition 1, select "Expression is" in the combo box, enter 
"[Checkbox1] = True" in the text box and select a fore/background 
combination.

4. Click OK


-- 
Stuart


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


This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law.  If you are not the intended recipient, you should delete this message. 


Any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. [v.E.1]



More information about the AccessD mailing list