Highlight a record

[David Portwood]

I have a form set up in Form View to look like a spreadsheet. I'm not sure
of my terminology (I don't have the form in front of me) but I believe it is
a continuous form - not a datasheet.

When the user moves from record to record, the record selector button shows
which record he is on. This is good, but I'd like to provide a more definite
visual cue. I have a "Delete Record" button which allows the user to delete
the current record but a couple of times the user has accidentally deleted
the wrong record. I thought if I could highlight the current record, these
kinds of mistakes would be less likely to happen.

I tried to add code to the Got Focus and Lost Focus field events to change
the back color of the active field and all other fields in the current
record. However, what happens then is entire columns change color, not just
the fields in the current record.

Is it possible to highlight just the current record in a continuous form
"spreadsheet-style" layout? What am I doing wrong?

 

[Ron2006]

I have a form set up in Form View to look like a spreadsheet. I'm not sure
of my terminology (I don't have the form in front of me) but I believe it is
a continuous form - not a datasheet.

When the user moves from record to record, the record selector button shows
which record he is on. This is good, but I'd like to provide a more definite
visual cue. I have a "Delete Record" button which allows the user to delete
the current record but a couple of times the user has accidentally deleted
the wrong record. I thought if I could highlight the current record, these
kinds of mistakes would be less likely to happen.

I tried to add code to the Got Focus and Lost Focus field events to change
the back color of the active field and all other fields in the current
record. However, what happens then is entire columns change color, not just
the fields in the current record.

Is it possible to highlight just the current record in a continuous form
"spreadsheet-style" layout? What am I doing wrong?

Try here for an example of one way of doing this:

http://www.lebans.com/conditionalformatting.htm

Ron