Conditional Formatting Help


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
 
Ad

Advertisements

A

Al Campagna

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

Advertisements

C

Chad

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

Thank you!

Chad
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top