Is it possible to change the text color in query view when it shows in datasheet view? I would like to change the text to red when the query runs.
Is it possible to change the text color in query view when it shows in datasheet view? I would like to change the text to red when the query runs.
Probably not but you could in a form in continuous form view.
You can do "some" conditional formating of query results. Specifically, for number data types.
Right-click on the column you want to apply the conditions to in query design view and select properties.
In the properties box that opens, you may specify conditional color formatting for numbers ... like this:
$#,###.000[Blue];($#,###.000)[Red];$0.000[Blue];$0.000[Blue]
I am looking for ways to do conditional text (meaning other than number data types) ...
But for numbers, this DOES work without having to build a form or report.