Look up Conditional Formatting in:
1) The Help Files
2) On GoogleGroups:
http://groups-beta.google.com/groups?hl=en&lr=&ie=UTF-8&safe=off&num=100
&q=Conditional+Formatting+group%3A*Access&safe=off
3) Basic CF stuff:
http://www.rogersaccesslibrary.com/TableOfContents3.asp
4) CF to make a Form resemble a Listbox:
http://www.datastrat.com/Download2.html
5) Two good MS KB articles on CF:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k
2/html/odc_conformat.asp
AND
http://support.microsoft.com/default.aspx?scid=kb;en-us;304104
6) Some other MS KB articles on CF:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000
/html/actbccolororotherformatsautomaticallychangewhenidontexpectit.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000
/html/acconaboutconditionalformattingonform.asp
http://support.microsoft.com/default.aspx?scid=kb;en-us;210263
Change the format of a text box or other control on a form or report
when it meets certain criteria
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000
/html/achowchangeformatofvalueincontrolwhenitmeetscertaincriteria.asp
7) Some advanced CF samples here:
http://www.lebans.com/conditionalformatting.htm
--
HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.