Change backgroud color for record listed in subform in continuous mode 
Author Message
 Change backgroud color for record listed in subform in continuous mode

Hi,
Access 2002. I have a form bound to a recordset. I can review the record
details in the main form. I also have a subform that list all records in the
recordset (just the name of each record). I would like to change the
background color in the subform for the record that is currently reviewed in
the main form. Any suggestions? Thank you.


Sat, 27 May 2006 09:37:29 GMT  
 Change backgroud color for record listed in subform in continuous mode
Look up Conditional Formatting in Access Help-- I believe you'll find what
you need.  I'm doing something similar, coincidentally!

Randall Arnold


Quote:
> Hi,
> Access 2002. I have a form bound to a recordset. I can review the record
> details in the main form. I also have a subform that list all records in
the
> recordset (just the name of each record). I would like to change the
> background color in the subform for the record that is currently reviewed
in
> the main form. Any suggestions? Thank you.



Sat, 27 May 2006 10:25:44 GMT  
 Change backgroud color for record listed in subform in continuous mode
Try Stephen Lebans' "Conditional Formatting":

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

--
HTH
Van T. Dinh
MVP (Access)


Quote:
> Hi,
> Access 2002. I have a form bound to a recordset. I can review the record
> details in the main form. I also have a subform that list all records in
the
> recordset (just the name of each record). I would like to change the
> background color in the subform for the record that is currently reviewed
in
> the main form. Any suggestions? Thank you.



Sat, 27 May 2006 21:53:57 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Continuous subform - change color of fields in current record

2. background color won't change in subform control (default continuous form)

3. background color won't change in subform control (default continuous form)

4. How to change backgroud color?

5. Changing Background Color Based on Record Data in a Continuous Form

6. Change the fore and background color of a selected record on a continuous form

7. Change the color of certain records of continuous form

8. changing each background color of each record in a continuous form

9. Changing the Background Color of the Current Record in a Continuous Form

10. Changing Background Color of Current Record in Continuous Form does not work in A2k dbase


 
Powered by phpBB® Forum Software © phpBB Group