Conditional Formatting in Tables

[jcbhydro]

Good Evening,

I have noted somewhere that conditional formatting is not possible in tables, but is there an alternative method of achieving a conditional background colour depending on data.

I have conditional formatting in Entry Forms and Reports associated with a table and I wish to display the same background colour in the subscriptions field of records in the table, when subsciption = 0.

Any suggestions would be welcomed.

 

[pbaldy]

I don't think it's possible. Most of us never allow users in tables or queries anyway. I'd use a form or report.

 

[Mile-O]

I have noted somewhere that conditional formatting is not possible in tables, but is there an alternative method of achieving a conditional background colour depending on data.

The reason it's not possible in tables is because, unlike Excel, tables are not for the presentation of data. They are for the storage of data. Just because tables, at first glance, look a bit like Excel doesn't mean they will do the same thing. If they did, there wouldn't be a point in having both Access and Excel.

If data is to be stored in a table, what are the other database elements for?

Queries, to question and manipulate your data.
Forms, to manage your date (add, edit etc.)
Reports, to display.
Macros/Modules for some slicker manipulation.

So, yeah, do your conditional formatting on a report. They are purposely designed to present data. Driven from the tables that store that data, of course.

Keep users out of tables and give them a form-based interface. Letting users directlty manipualte the data can, and most likely will, throw up errors you can otherwise plan for and offset.