DaveK said:
When I display a table in Access, is it possible to
display one row in a different color from the rest based
on the value of one of the fields in that row? Sort of a
format on condition, but that applies only to one row.
Hi Dave,
Here be one method I use:
View your table/query in a form or report
(as a general rule, you should be doing this
anyway).
In a continuous form bound to your table/query,
- create a textbox as wide and tall as Detail Section
-click on Format/Move To Back so always behind
everything
- set its Control Source to equality, i.e.,
= something = something
- set all other controls to transparent background
- set this control's background to very light gray (or you choose)
and font color to same color
- with this control selected, click on Format/Conditional Formatting
for condition,
if "Field Value" "equal" -1
set its background color to white (or you choose)
and its font color to same color
Result:
all rows in continuous form have light gray background
except rows where "something=something" which stand
out because background is white.
Works the same in reports.
Maybe you can adjust for your situation. Works for me.
Good luck,
Gary Walter
