Highlight Selected record

  • Thread starter Thread starter Rudi Groenewald
  • Start date Start date
R

Rudi Groenewald

Hi guys,

I've got a form where you lookup records from a table which transfers a
userID to a different form upon doubleclick. This is achieved by a form in
datasheet view.

How can I Highlight the selected record with a different color when it is
selected in my form?

Thanks alot in advance
 
Conditional formatting allows this.

Depending on how your form is set up depends on how complex this becomes.

The simplest way is to create a text box as long as your row, and place it
behind the rows data boxes. Give this text box a name like txtColor.

Then using conditional formatting tell the conditional format to change the
color of this text box to something else.

The data text boxes over the top must have their background set to
transparent.

HTH
 
Hey thanks Dynamicpool, works like a dream.


dynamicpool said:
Conditional formatting allows this.

Depending on how your form is set up depends on how complex this becomes.

The simplest way is to create a text box as long as your row, and place it
behind the rows data boxes. Give this text box a name like txtColor.

Then using conditional formatting tell the conditional format to change the
color of this text box to something else.

The data text boxes over the top must have their background set to
transparent.

HTH
Click to expand...
 
Back
Top