background color on continuous forms

[nkrst1]

I have a continuous form with fields: Employee ID, Name, Title, In/Out (dropdown box), and comments. This is for a headcount tracker that tracks when people leave or enter departments based on transfer, new hire, terminations, etc. I want to color code them so that at a glance you can see who left or entered a department. For example, if the drop down box says "IN" - I want to color the record blue somewhere. But you can't use the backcolor property because it colors the field for every record...

Any suggestions?

 

[thornmastr]

If you are using A2K or higher you can do this with conditional formatting. It is in Access Help.

If you are using A97 see this web page.

http://www.mvps.org/access/forms/frm0047.htm

Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com