Highlight a record

  • Thread starter Thread starter Gord
  • Start date Start date
G

Gord

Is it possible to highlight non-contiguous records in VB? If so, how is it
done?

After examining a recordset with code, I want to highlight those records
that I want to bring to the users attention. The whole record doesn't
necessarily have to be highlighted/selected but I just want some way of
visually flagging those (usually non-contiguous) records I want the user to
look at.

Thanks,

Gord
 
Hi Gord,

I don't know whether this will help but thought I should share the idea with
you.

I have a system where I use a continuous form to run an on screen exception
report displaying the records that don't meet certain criteria (usually
missing fields). I assume you could do something similar because you have
said you are running code to identify specific records that need examining.
The user can then double click the record Id and the Double Click event opens
the main editing form and the problems can be handled.

In addition to opening the main editing form, in the header of the
continuous form I have a dummy text box which is hidden. When the user double
clicks a record Id, the code copies the Id to the dummy text box. I have
conditional formatting set so that when the record Id matches the dummy
textbox, the record Id background is yellow. This marks the position that the
user is up to when they return to the continuous form to get the next record.

Let me know if you want any more information on this.
 
Back
Top