Highlight the entire row when mouse moves over the row (1 Viewer)

Hi every one

Is there any way to highlight the entire row when mouse moves over the row in the continuous form?

If any suggestions please share

foxtet

If you had a single control *behind* the row and all of the controls were transparent, I would think it could be done.

RuralGuy said:

If you had a single control *behind* the row and all of the controls were transparent, I would think it could be done.

Click to expand...

Can it be done by coding?

Sure "If you had a single control *behind* the row and all of the controls were transparent."

drag an unbound textbox on the detail section of your form.
delete its associated label control.
name the textbox txtHidden. set its Visible property to False.

on the current event of your form, set txtHidden to the value of your PK field in the form.

private sub form_current()
me.txtHidden = me.PKTextBoxControl
end sub

next select all controls on your form (textboxes, comboboxes) and do the Conditional format.
use
Expression: [txtHidden] = [PKTextBoxControl] => choose color you want.

for new record (if you want to set new conditional format)

Expression: [txtHidden] Is Null And [PKTextBoxControl] Is Null => choose color you want.