E
EER
I have a situation where I need to color-code rows in a MS Access 2007 table
based on when the data was added to the database.
Since the background highlight feature won't highlight individual rows (only
All Rows), I thought I would set the datatype of a column to Memo/Rich Text,
and change the color of the text in some of the rows in that column (either
the text itself or the background color).
Can anyone suggest a macro that would set the background or text color for a
range of rows in a rich-text Memo-datatyped column?
I will need to do this more than once, so I would need to specify both the
range and color to set when running the macro.
Thanks in advance,
Jack
based on when the data was added to the database.
Since the background highlight feature won't highlight individual rows (only
All Rows), I thought I would set the datatype of a column to Memo/Rich Text,
and change the color of the text in some of the rows in that column (either
the text itself or the background color).
Can anyone suggest a macro that would set the background or text color for a
range of rows in a rich-text Memo-datatyped column?
I will need to do this more than once, so I would need to specify both the
range and color to set when running the macro.
Thanks in advance,
Jack