Turn a whole Record Row a different color

[tkosel]

I have several users who like the entire row for a record to have a different
background color from adjacent records. I have done it with conditional
formatting by setting a field value to 1 when any field in that record has
the focus. This works pretty good in a single user environment. However,
when multiple users are accessing the same recordset, records other than the
one that user has open will also meet the conditional format and be yellow.
Can anyone think of a way to turn all fields in a single record to a
different background color without affecting records on other computers?

 

[Klatuu]

If you have mutilpe users sharing the same copy of your application, you are
making a serious mistake. You should split your database. Put the _be.mdb
file (contains alll the tables and relationships) on a shared folder where
all users have read and write permissions. The give each user their own copy
of the front end mdb (cotains forms, macros, modules, queries, etc).

 

[tkosel]

I was not specific enough, sorry. I do have a back end front end
configuration. However to cut down on installation issues, (Version control,
etc.) I do have all users sharing the same front end. I think that you have
answered my question in that probably the proper way to do what I want is to
have everyone use their own copy of the front end. Thanks for your input.