Subform

  • Thread starter Thread starter Senad Isanovic
  • Start date Start date
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!
 
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
 
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?
 
Back
Top