Thanks Bill,
For me you have definitely hit the operative word on the head OLD (days).
Glenn
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of wrmosca@comcast.net
Sent: Wednesday, March 19, 2014 1:17 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Re: Continuous form conditional format
Not so, Glenn. With conditional formatting the control must be bound, but that's the only thing necessary for it to work. In the old days before conditional formatting you would be exactly right because continuous forms only have one set of controls so changing one for one record would affect all of them. CF gets around that.
Bill
---In MS_Access_Professionals@yahoogroups.com, <argeedblu@gmail.com> wrote :
IIRC, on a continuous form, any format changes will affect all displayed records not just the current record.
Glenn
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of wrmosca@comcast.net
Sent: Wednesday, March 19, 2014 11:36 AM
To: MS_Access_Professionals@yahoogroups.com
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 (5) |
Tidak ada komentar:
Posting Komentar