Unanswered: How to set current record visual attribute?
In an Access datasheet, I like to show all my current record row (where my cursor is) in some color. How to achieve that? Note that all fields in the current row will be in color, not just the particular field where cursor is.
This is probably not easily possible. There might be a way using the windows api but it's gonna be real hard getting the handles to the controls I guess (after that it should go quite smoothly). Conditional formatting would only work with distinct values in each field and is also not updating when you want it to (e.g. OnCurrent). The best you can do is color the field having the focus (using conditional formatting).