 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Database Design / July 2005Change Row Color if Field Value=Yes
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).  SignatureDuane Hookom MS Access MVP -- >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. 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. > You should be able to use conditional formatting in a form. This would > depend on your version of Access (2000 or later). [quoted text clipped - 3 lines] > > > > Thank you. Have you checked Help yet? Have you opened your form in design view and messed around with conditional formatting? SignatureDuane Hookom MS Access MVP -- >I have Access 2003. Would you be able to give me specific instructions on > how to set this up? I'm not that advanced. [quoted text clipped - 9 lines] >> > >> > Thank you. 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? [quoted text clipped - 12 lines] > >> > > >> > Thank you. Don't/can't do it in a table. Users should view/edit records in forms, not tables. SignatureDuane Hookom MS Access MVP -- > It's not a form, it's a table. > [quoted text clipped - 16 lines] >> >> > >> >> > Thank you. 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? > Don't/can't do it in a table. Users should view/edit records in forms, not > tables. [quoted text clipped - 19 lines] > >> >> > > >> >> > Thank you. Consider reading #2 at this link http://www.mvps.org/access/tencommandments.htm. What's wrong with creating forms for entering and editing records? SignatureDuane Hookom MS Access MVP -- > So you're saying that I can't change the color of one row in a table based > on [quoted text clipped - 28 lines] >> >> >> > >> >> >> > Thank you. 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. > Consider reading #2 at this link > http://www.mvps.org/access/tencommandments.htm. [quoted text clipped - 33 lines] > >> >> >> > > >> >> >> > Thank you. 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. SignatureDuane Hookom MS Access MVP -- >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. [quoted text clipped - 39 lines] >> >> >> >> > >> >> >> >> > Thank you. >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. SignatureLynn 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 You can't, period, which is exactly what Duane told you. The only solution has been pointed out by Duane as well. -- Stephen Lebans http://www.lebans.com Access Code, Tips and Tricks Please respond only to the newsgroups so everyone can benefit. > 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? [quoted text clipped - 37 lines] > > >> >> > > > >> >> > Thank you. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.