change colors on selected record

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.
 
F

fredg

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.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top