how can i highlight a selected row in form?

[joe55555]

hello, i have a big access file with forms macros and vba. in one form i have 4 subforms in one of the 4 sub forms i have a list of more than 100 records (rows) and each row has many controls like text boxes, labels, .... when i click on any row i see a small black arrow on the left of each row designing the record i am in. so i want to highlight the record i select and if it is possible i want this highlight to show no matter on which control of the row i click on because i have many and the user may click every time a different control. thanks

[June7]

Sorry, Access doesn't have that behavior, at least not intrinsically. I doubt it can be done programmatically.

If form in Datasheet view, clicking on the RecordSelector will select entire record but clicking in a field selects only that field.

[ssanfu]

I have done something like this.... Have to add a Boolean field to the table, then some code and conditional formatting.

How close is this?? (see attached mdb - A2000 format)

[joe55555]

ssanfu

that's exactly what i am looking for thank you very much for your help

[ssanfu]

Excellent.......