Still trying to change the color of one line in the detail section

G

Guest

I am still having trouble finding a way to isolate one record of the detail
section of a continuos form and change the properties of all of the controls
with in that record. Because it is a continuos form, I can have a number of
records in the detail section of this form. Each record contains simple text
boxes. What I want to do is afterupdate of one of the text boxes on that
record, I want to change the backcolor of all the controls on that particular
record to RED. I want to continue to do this on any record I happen to
update/change. But I want just the record I changed to turn Red...Not all.
Right now I put simple code in to change the back color to red and it turns
all of the detail lines to red. Can this be done? Help
 
R

RuralGuy

I am still having trouble finding a way to isolate one record of the
detail section of a continuos form and change the properties of all of
the controls with in that record. Because it is a continuos form, I
can have a number of records in the detail section of this form. Each
record contains simple text boxes. What I want to do is afterupdate of
one of the text boxes on that record, I want to change the backcolor
of all the controls on that particular record to RED. I want to
continue to do this on any record I happen to update/change. But I
want just the record I changed to turn Red...Not all. Right now I put
simple code in to change the back color to red and it turns all of the
detail lines to red. Can this be done? Help

Have you looked here yet?
http://www.lebans.com/conditionalformatting.htm

HTH
 

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