highlight rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to change color (or somehow differentiate) some rows of an
Access 2000 database table without changing the color of the entire table?
 
Yes, in your form or report, use the CONDITIONAL FORMATTING feature.

You can set the formatting based on the current field, or you can enter an
expression.

So, let's say you have six fields on a row and you want them to show up red
if the field "Active" is checked...

You'd highlight each control in that row and set the conditional formating.
You'd use the "Expression is" item from the first drop-down, then you'd use
an expression like "[Active] = true"

Good luck.

--
Rick B



KMT said:
Is it possible to change color (or somehow differentiate) some rows of an
Access 2000 database table without changing the color of the entire
Click to expand...
table?
 
I want to highlight a row and change the color. There is no one particular
rule that I can set for conditional formatting. Can this be done?

Thanks!

Rick B said:
Yes, in your form or report, use the CONDITIONAL FORMATTING feature.

You can set the formatting based on the current field, or you can enter an
expression.

So, let's say you have six fields on a row and you want them to show up red
if the field "Active" is checked...

You'd highlight each control in that row and set the conditional formating.
You'd use the "Expression is" item from the first drop-down, then you'd use
an expression like "[Active] = true"

Good luck.

--
Rick B



KMT said:
Is it possible to change color (or somehow differentiate) some rows of an
Access 2000 database table without changing the color of the entire
Click to expand...
table?
Click to expand...
 
What do you mena "Highlight it"? If you add a checkbox to your record, you
could "select it" by checking that box, then use conditional formatting to
test for that box.



--
Rick B



KMT said:
I want to highlight a row and change the color. There is no one particular
rule that I can set for conditional formatting. Can this be done?

Thanks!

Rick B said:
Yes, in your form or report, use the CONDITIONAL FORMATTING feature.

You can set the formatting based on the current field, or you can enter an
expression.

So, let's say you have six fields on a row and you want them to show up red
if the field "Active" is checked...

You'd highlight each control in that row and set the conditional formating.
You'd use the "Expression is" item from the first drop-down, then you'd use
an expression like "[Active] = true"

Good luck.

--
Rick B



KMT said:
Is it possible to change color (or somehow differentiate) some rows of an
Access 2000 database table without changing the color of the entire
Click to expand...
table?
Click to expand...
Click to expand...
 
Back
Top