mrmad1966
asked on
How can I change the background colour for a specific row in a table
How can I change the background colour for a specific row in a table, based upon the string value in one of the fields. eg If the original data in one of the tables rows is edited one of the fields will have the string Amend entered. I would then like the row in that table to be coloured orange (a simple visual indicator for the end user that something has changed.)
Please be patient with me as an access newbie..
Thanks for reading
Please be patient with me as an access newbie..
Thanks for reading
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The simplest way to do it for an entire row is to create a textbox that spans the entire row and move it behind the other controls. Set the other controls to be transparent. Then you can control the color of the background control and that will change the background for all the "front" controls.
This method does not work on a datasheet form but it will work on a continuous or single view form or on a report.
This method does not work on a datasheet form but it will work on a continuous or single view form or on a report.
Pat, it will do that for all records, not a specific one.
The olde trick is to set the foreground colour of that textbox and then bind it to a function that returns Null for common records and a bunch of the White Space character for the specific record.
gustav
The olde trick is to set the foreground colour of that textbox and then bind it to a function that returns Null for common records and a bunch of the White Space character for the specific record.
gustav
Conditional formatting only affects the current record. I guess I didn't make it clear that we were still talking about using conditional formatting. You use the "Expression Is" option but attach it to the field you want to color rather than the field you want to examine.
I forgot about the olde trick it's been so long since I had to use it. Too bad even that won't work for DS view. In DS view, the only option is to colorize each control independently because you can't use the stacked controls trick.
While we're at it, it's also too bad that the conditional formatting option doesn't use theme colors. You have to be careful so you don't conflict with the theme you are using. The results can be jarring.
I forgot about the olde trick it's been so long since I had to use it. Too bad even that won't work for DS view. In DS view, the only option is to colorize each control independently because you can't use the stacked controls trick.
While we're at it, it's also too bad that the conditional formatting option doesn't use theme colors. You have to be careful so you don't conflict with the theme you are using. The results can be jarring.
ASKER
Thank you everyone.
What Access version and what kind of "table" are you talking about?