Subform

S

Senad Isanovic

I have sub form with several number of records (different numbers of records
depending on different search). Now I 'd like to select the record
(different backcolor or bold text) where the cursor is. How can this be
done? (I'm using Access 2003) Thanks!
 
O

Ofer

Use the got focus and lost focus of the field to change the back color

Private Sub FieldName_GotFocus()
Me.FieldName.BackColor = 255 'Red
End Sub

Private Sub FieldName_LostFocus()
Me.FieldName.BackColor = 16777215 ' White
End Sub
 
S

Senad Isanovic

There are 10 fields in the record, do I need to change the backcolor for all
of them? "Me" referes to a single field. Is there any "Me" that referes to
the whole record?
 
Top