Conditional Formatting Help

  • Thread starter Thread starter Chad
  • Start date Start date
C

Chad

I have a form that uses a yes/no tickbox. When the tickbox is
selected, the records on the form are locked. I would like to create
a conditional format for the records to shade grey when the yes/no box
is ticked.

I've tried selecting the records, open conditional formatting, under
condition 1, creating an expression that says "Archive"=-1. Archive
is the control source of the tickbox. I assumed -1 would relate to
yes/ticked. I've also tried "Archive"=True.

Thanks in advance.

Chad
 
Chad,
You need to refer to the Name property of the checkbox control,
not the ControlSource.
I'll assume that the Name is Archive also.
In that case... set the color when...

Expression Is [Archive] = True
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Thanks so much, Al! Works perfect. My name property was lower case
(archive) :)

Thank you!

Chad
 
Back
Top