I have a situation where I need to color-code rows in a MS Access 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