Change Row Color if Field Value=Yes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a yes/no check box field. If the value = yes I would like to change
the color of that particular row. Is there a way to accomplish this?

Thank you.
 
You should be able to use conditional formatting in a form. This would
depend on your version of Access (2000 or later).
 
I have Access 2003. Would you be able to give me specific instructions on
how to set this up? I'm not that advanced.

Thank you.
 
Have you checked Help yet? Have you opened your form in design view and
messed around with conditional formatting?
 
It's not a form, it's a table.

Duane Hookom said:
Have you checked Help yet? Have you opened your form in design view and
messed around with conditional formatting?
Click to expand...
 
So you're saying that I can't change the color of one row in a table based on
criteria? I find that hard to believe. Anyone else know a way?
 
I don't have users. I am a lone creator and user of a database. I simply
want to change the color of a row based on Yes/No.
 
Maybe you should start a new thread with a subject like "Conditional Format
Record color in table view"? See if you find anyone who can suggest anything
other than what I have already suggested.

I don't think you will have much success but it might be worth trying.
 
You can't, period, which is exactly what Duane told you. The only
solution has been pointed out by Duane as well.
 
I don't have users. I am a lone creator and user of a database. I simply
want to change the color of a row based on Yes/No.
Click to expand...

I don't want to add insult to injury, but as Duane and Stephan have both
said, "It ain't gonna happen." Tables are designed for storing data and have
only limited formatting capabilities. It's easy enough to create a Datasheet
form that displays your table's data and with which you can use conditional
formatting, as Duane explained. You'll be much happier if you don't try to
fight the way Microsoft built Access.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html
 
Back
Top