Re: [MS_AccessPros] Re: Continuous form conditional format

 

That works great! Until I share the front end with other users and the colors don't change. I still see the logic for the conditional formatting but it doesn't work.

 

."The only real mistake is the one from which we learn nothing."     
       John Powell (1834-1902)

"Patience is the companion of wisdom." 
        Saint Augustine (354 AD - 430 AD)

"Success is the ability to go from one failure
               to another with no loss of enthusiasm."
       Sir Winston Churchill (1874 - 1965)

---

From: "wrmosca@comcast.net" <wrmosca@comcast.net>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, March 19, 2014 10:36 AM
Subject: [MS_AccessPros] Re: Continuous form conditional format

 

John

Select the text box in design view. Use Conditional formatting and select "Expression" as the type. Put something like this in the expression box: 

[myCheckBox]=True

You'll need 2 conditions: one if the checkbox is true and one if it is false.

Regards,

Bill Mosca, Founder - MS_Access_Professionals

http://www.thatlldoit.com

Microsoft Office Access MVP

http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

---In MS_Access_Professionals@yahoogroups.com, <shelbysalpha@yahoo.com> wrote :

Is there a way to have check box on a record control the background color of a text box on the same record of a continuous form? 

 

."The only real mistake is the one from which we learn nothing."     
       John Powell (1834-1902)

"Patience is the companion of wisdom." 
        Saint Augustine (354 AD - 430 AD)

"Success is the ability to go from one failure
               to another with no loss of enthusiasm."
       Sir Winston Churchill (1874 - 1965)

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (6)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___