Highlight row in Continuous Form

Question

I have a continuous form that is quite wide.  When the user is trying to read across, its somewhat hard to follow across.  So, I would like to have the user select the record using the record selector and change the background color of the records in that row or highlight it in some way.  Is this possible?

Answer 1

Try playing around with Conditional Formatting:

Highlight all the fields in Design view and the choose Format Design Tools, Design, Conditional, from the drop down for condition 1 select Field Has Focus, pick a color.

Experiment.  Hope this helps.

---

If this answer solves your problem, please check, Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers Shane Devenshire

Answer 2

An additional point you can Freeze any column you want and it will stay in view in the leftmost position.  That is done by right-clicking a field title and choosing Freeze Columns (in the Form View)

---

If this answer solves your problem, please check, Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers Shane Devenshire

Answer 3

An alternative to highlighting only the control with the focus or using Conditional Formatting on every control is to add a text box with BackColor set to whatever BackColor you use on the other controls.  Size this text box to cover the entire detail section and use Format - Send to Back to put it behind all the other controls.  Then select all the other controls and set their BackStyle to Transparent.

Next, add an invisible text box (named txtCurrent) to the form header or footer section (or even the detail section) and set its value in the form's Current event:

   Me.txtCurrent = Me.[your primary key field]

Now, you can use CF on the one big text box to highlight the entire row.  Use the Expression Is option with an expression like:

   [your primary key field] = [txtCurrent]

and selecting the back color of your choice.

Answer 4

Thank you so much! I have been trying every suggestion I could find, and yours works like a charm!

Answer 5

Thank you for the great code.