continuous form - one field change the background colour, current record

[Elsw]

Hi, in a continuous form i want to click on one record and have the one field change the background colour to highlight it. When I use the code: Field.BackColor = vbYellow it changes the background on all the records. Is there a code to say only for the record with focus?

 

[vbaInet]

Try this:
1. Place a textbox in the header section of the form, let's call it txtCurrent
2. Enter the field name of the ID into the textbox's Control Source, i.e. =ID
3. Refer to the textbox in the Conditional Format:

[B][I]Expression Is[/I][/B]
[ID] = [txtCurrent] AND [COLOR="Blue"]... your condition here ...[/COLOR]