Yes it works for me but after emailing the front end to another co-worker and opening it on their computer the colors do not change. I checked the programming and it is still there. Sorry if you think "that is just not possible" but that IS what IS happening.
."The only real mistake is the one from which we learn nothing."
John Powell (1834-1902)
John Powell (1834-1902)
"Patience is the companion of wisdom."
Saint Augustine (354 AD - 430 AD)
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)
to another with no loss of enthusiasm."
Sir Winston Churchill (1874 - 1965)
From: Bill Mosca <wrmosca@comcast.net>
To: MS_Access_Professionals@yahoogroups.com
Sent: Thursday, March 20, 2014 5:01 PM
Subject: RE: [MS_AccessPros] Re: Continuous form conditional format
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
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)
John Powell (1834-1902)
"Patience is the companion of wisdom."
Saint Augustine (354 AD - 430 AD)
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)
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
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)
John Powell (1834-1902)
"Patience is the companion of wisdom."
Saint Augustine (354 AD - 430 AD)
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)
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 (8) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar