I am using Access 2013, and have a continuous form on which I want to highlight the selected row. I have it working using the solution described here: http://answers.microsoft.com/en-us/office/forum/office_2007-access/highlight-row-in-continuous-form/a862821f-ebee-4ebc-93d9-e068debcab84
1. the form controls have been made transparent and placed on top of a long textbox.
2. An invisible text box (named txtCurrent) is placed in the form header. This has its value set to the primary key field in the form’s Current event: Me.txtCurrent = Me.[primary key field]
3. The long textbox has been conditionally formatted using the Expression Is option: [primary key field] = [txtCurrent]
…and its background set to the desired highlight color.
However, I find that every time a new row is selected, the form content “jumps” quite noticeably. I am not sure why this is, but does anyone know of an alternative way to highlight rows without the form content jumping every time ? Sorry to be finicky ! I have searched quite a bit for a way to solve this, but couldn’t find anything. Thank you advance for any help.