Highlight current record on continous form

[Wysy]

Hi,
I am trying to solve this: i would like to highlight the record/control having focus. I have seen several solutions but i wonder which one is the best for Office 365.
thank you
Andrew

 

[arnelgp]

use Conditional Format, when the Field Has Focus.

 

[Wysy]

Thank you, but it changes all the fields on CF form.

 

[isladogs]

Have a look at the method used in the emulated split form http://www.mendipdatasystems.co.uk/emulated-split-form/4594398119

 

[Wysy]

Thank you so much. I found this as well:

"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."

It pretty much does the job...
Thank you for the help!

 

[isladogs]

That's basically the same idea....
Anyway, for the benefit of others reading this thread, please provide a link for the quote you supplied.
Thanks

 

[Wysy]

sorry for not providing...

Highlight row in Continuous Form

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

answers.microsoft.com

 

[isladogs]

Thanks