Highlight a complete record "On Click" of a field

[Guest]

Hello.
I have two seperate very wide forms:
-Continuous form
-Datasheet suform

"On click" of any field in a record I would like for the background of the
whole record to become high lighted in yellow so that I can follow which
record I am working on all the way across the very wide forms.

How can you do this? Would there be different solutions for the two
different forms?


Thanks.
Iram/mcp

 

[Marshall Barton]

I have two seperate very wide forms:
-Continuous form
-Datasheet suform

"On click" of any field in a record I would like for the background of the
whole record to become high lighted in yellow so that I can follow which
record I am working on all the way across the very wide forms.

How can you do this? Would there be different solutions for the two
different forms?

Yes. Datasheet forms only display the data controls so you
you would have to apply Conditional Formatting to every
control.

Continuous forms display the detail section's background
wherever it is not covered by a control. To get a different
color over the entire section, add a text box that is the
same size as the detail section, set its Backcolot to the
same value as the detail section and use Format - Send to
Back to put it behind all the other controls. Maybe even
set all the other control's BackStyle to Transparent? Then
you can use CF for just the one big text box/

Either way, you need to add a text box (named txtCurrent) to
the form's header section and use the form's Current event
to set the text box's value to a unique identifier for the
records:
Me.txtCurrent = Me.thePKfield
Then, the CF - Expression Is setting for the big text box
would be like:
[thePKfield] = [txtCurrent ]