Color Coding

A

akemeny

Is there a way to color code the rows?

Currently we have our spreadsheets in Excel and we utilize a color coding
system to let us know what stage the claim is in, but I haven't found a way
to do that in access as of yet.
 
A

Arvin Meyer [MVP]

To some extent, you can use Conditional Formatting. In Design View look at
the Format menu. That allows for 3 colors. You will probably need to use a
Continuous Form designed, if so desired, to look like a datasheet.
 
T

Tom Wickerath

To add some to Arvin's reply, have a look at my tutorial on implementing
Conditional Formatting. This is probably more appropriately applied to a
single field in your form, instead of the entire record, but I suppose it
could be applied to the entire record if you really wanted to do this.

Conditional Formatting
http://www.access.qbuilt.com/html/conditional_formatting.html


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
R

roccogrand

Another solution is to upgrade to Access 2007 where the program provides
several color coding options out of the box.

LDN
 
Top