Change font color in tables

  • Thread starter Thread starter dimpie
  • Start date Start date
D

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
 
Tables do not have such properties for fields. You must use a form to do
what you seek.
 
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
Click to expand...

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.
 
Back
Top