Since the sample MDB is to demonstrate the use of Conditional Formatting
I thought it was safe to assume that inquiring minds would at least
examine the ConditionalFormatting for the affected controls.
Select any of the TextBox controls(or all of them) in form Design view
From the Format Menu select Conditional Formatting
Notice the Condition 1 is setup as:
Expression Is [txtcusActive]
The Font is Bolded with a Red Forecolor.
So when CF evaluates each row, if the txtCusActive CheckBox control is
equal to TRUE then it will apply the Conditional Formatting to the
TextBox control.
--
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
<ce*******@yahoo.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...
Re: A2KConditionalFormattingVer27.mdb
I downloaded his sample database, and the field 'format' property was
the first thing I checked. That's why I assumed it must be code. But I
cant find anything. It will be nice if it's something simple that I'm
overlooking, but I suspect not. Only Stephan knows.
I appreciate what he's done, I think it's fabulous, but I can't use it
if I dont know the specs. or how to manipulate it.
I also experimented with the check box and the associated text boxes.
There seems to be some kind of awareness between them.
The check box can be any new check box from the 'toolbox' tool bar,
but....it's name MUST be "txtcusActive".
The text box has to be a COPY of the one used in the sample database.
It's name can be anything...
I also noticed if you use the format painter on a new text box, it
inherits the properties of the sample db text box.
The text box seems to be aware of the 'txtcusActive' check box state
and responds by changing color.
If I haven't overlooked anything, this tells me that the TEXT BOX is
sub-classed or whatever the process it called when you take a standard
windows control and add more funtionality to it.
I'd love to use it, but if I cant manipulate the color or how it
responds, I just simple cant. It's an excellent trick, though.
Still waiting for an answer...