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?
Access 2000 database table without changing the color of the entire table?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick B
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
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
table?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
G
Guest
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!
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
table?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
R
Rick B
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
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
table?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