 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / September 2005Change Record colour if criteria not matched
Hi, is there a way to have a record change color if certain criteria is not matched? for example my database has records based on date issued and date recieved, so if the date recieved is null or date issued+7 days < current system date that record should change to red any help mucho appreciated!! Cheers Conditional Formatting is your friend. While in form or report design, go Format > Conditional Formatting. HTH, Nikos > Hi, > [quoted text clipped - 8 lines] > > Cheers Appreciate that Nikos........... but what happens if it is in Access 97...........? > Conditional Formatting is your friend. While in form or report design, > go Format > Conditional Formatting. [quoted text clipped - 14 lines] > > > > Cheers > but what happens if it is in Access 97...........? So, conditional formatting as not available in A97? Sorry, I haven't used A97 for years, I didn't know. You could use some simple code to do it, the catch is it will only work in single form view; in continuous forms view you cannot change the format settings for a single record, whatever change is applied to all records at once. Nikos >> but what happens if it is in Access 97...........? > So, conditional formatting as not available in A97? Sorry, I haven't [quoted text clipped - 4 lines] > > Nikos And then there is always Stephan Lebans: http://www.lebans.com/conditionalformatting.htm HTH  SignatureRuralGuy Please reply to the newsgroup so all may benefit. > And then there is always Stephan Lebans: > > http://www.lebans.com/conditionalformatting.htm Of course... the only problem is, the first line on the page reads: A2K or Higher Only! > Of course... the only problem is, the first line on the page reads: > > A2K or Higher Only! Oops...<shuffling feet and looking stupid> SignatureRuralGuy Please reply to the newsgroup so all may benefit. Don't worry, it happens to everyone from time to time. Been there, and I'm sure I'll be there again! now where were we.....ah yes any recommendations as to how to achieve this? > Don't worry, it happens to everyone from time to time. Been there, and > I'm sure I'll be there again! Did you ever get an answer as to wheather or not ths can be done. If I understand you correctly, you want the change to take place when the query is ran? I have a field that is for disputed items, when the Cm's run thier daily queries if an item has been marked "Disputed" I need the record to change to red. I don't use reports just queries, and I have a main form where the queries are listed. > now where were we.....ah yes any recommendations as to how to achieve this? > > > Don't worry, it happens to everyone from time to time. Been there, and > > I'm sure I'll be there again! |
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.