John
Are you saying it works for you but no one else? That's just not possible. Can you elaborate?
Regards,
Bill
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of John Heinze
Sent: Thursday, March 20, 2014 2:26 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: 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
Microsoft Office Access MVP
My nothing-to-do-with-Access blog
---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 (7) |
Tidak ada komentar:
Posting Komentar