change colors on selected record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I already check the existing threads and I could not find an answer to my
question.

I have a continuous form with eleven columns. What I want to do is change
the back/fore colors on all the fields for the selected record. At this time
only a field changes color (Whatever the default is in the acces form). So If
the user selects record 20, the entire record changes colors, when the user
selects record 10, record 20 goes back to the original colors and record 10
changes colors, etc.

Thanx.
 
I already check the existing threads and I could not find an answer to my
question.

I have a continuous form with eleven columns. What I want to do is change
the back/fore colors on all the fields for the selected record. At this time
only a field changes color (Whatever the default is in the acces form). So If
the user selects record 20, the entire record changes colors, when the user
selects record 10, record 20 goes back to the original colors and record 10
changes colors, etc.

Thanx.
Click to expand...

Access 2002 or newer?
See
http://www.lebans.com
specifically:

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

You can down load a sample database that includes various uses for
shaded lines, including continuous form alternating lines and
highlighting the selected line.

And also look at:
http://www.lebans.com/alternatecolordetailsection.htm
 
Back
Top