I just came up with a crazy thought. I was passing over a query's records, looking at some column at the end of the records, but every now and then I had to check that one of the columns at the beginning of the record has not changed.
And then I thought that sliding back and forth of the record's column is stupid, and thought that it could be great if by left-clicking the column name (at the beginning) I could choose a color by option, and then all the records colors will change according to its value (from a preset color theme). If the field is numeric/date, the color could be gradient.
Here are my mspaint simulations for the (imagined) looks of it:
- colorby.png (17.57 KiB) Viewed 21927 times
- colorby2.png (10.2 KiB) Viewed 21927 times
- colorby3.png (12.04 KiB) Viewed 21927 times
Hope this makes sense. What do you think?
Amos.