Change Row Color if Field Value=Yes

[Christine Lisi]

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.

 

[Duane Hookom]

You should be able to use conditional formatting in a form. This would
depend on your version of Access (2000 or later).

 

[Christine Lisi]

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.

 

[Duane Hookom]

Have you checked Help yet? Have you opened your form in design view and
messed around with conditional formatting?

 

[Christine Lisi]

It's not a form, it's a table.

Have you checked Help yet? Have you opened your form in design view and
messed around with conditional formatting?

 

[Duane Hookom]

Don't/can't do it in a table. Users should view/edit records in forms, not
tables.

 

[Christine Lisi]

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?

 

[Duane Hookom]

Consider reading #2 at this link
http://www.mvps.org/access/tencommandments.htm.

What's wrong with creating forms for entering and editing records?

 

[Christine Lisi]

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.

 

[Duane Hookom]

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.

 

[Stephen Lebans]

You can't, period, which is exactly what Duane told you. The only
solution has been pointed out by Duane as well.

 

[Lynn Trapp]

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.

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