Change font color in tables

[dimpie]

Can a font color be changed in the table depending on a condition.

For Eg,
If a table had numeric field, i could write a update query to identify the
results i would like to change the font color for. But how can i change the
font color.

IIF(FIELD1 > 30, change font color to red)

I can do this is the form too. But there is this one weird scenario that i
need this for.

Please help! Thanks

 

[Ken Snell [MVP]]

Tables do not have such properties for fields. You must use a form to do
what you seek.

 

[John W. Vinson]

Can a font color be changed in the table depending on a condition.

For Eg,
If a table had numeric field, i could write a update query to identify the
results i would like to change the font color for. But how can i change the
font color.

IIF(FIELD1 > 30, change font color to red)

I can do this is the form too. But there is this one weird scenario that i
need this for.

Please help! Thanks

You can do this on a Report (for printing) or a Form (for onscreen display),
using Format... Conditional Formatting; but you cannot in a table datasheet.
Just one of the many limitations of table datasheets, and reasons why they
should not be exposed to users.