Conditional Formatting Help

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."


"Chad" wrote in message
...
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

Thanks so much, Al! Works perfect. My name property was lower case
(archive)

Thank you!

Chad