MS Access 2007 Table Conditional Formatting?

Question

I'm creating an Access Database for a companies finances in Access 2007, and I need some help with something I've never tried before. I know forms and reports you can create conditional formatting, but what about Sheets? I have a table with records, and here's what I want to do:

If the cell Category (A drop down category list) has Payroll Selected, then make the cells under FICA, Mcare, and Net for that specific record have a white background.

If cell Category has anything else selected, then make those same cells for that record have a black background.

I don't know where to start. I'm guessing it has to do with Verification Rule or Text in the Design view, but I could be wrong, and if I'm right, I'd have no clue how to program that. Any help would be great!

Answer 1

Tables just store data.  They only LOOK like Excel spreadsheets because that is the simplest way to view the data.

The "Validation Rule" is designed to make sure the data is the correct TYPE and FORMAT (like a DATE rather than a TIME or a DOLLAR).

To do conditional formatting You design a FORM based on the TABLE, Display it in "DATASHEET" view, and set your custom formatting for each field.  in 2000 & 2007 there is a wizard for doing JUST THAT...