Change the color of records in a table

[Pusher]

Hi all,
Can you change the color of lines of records in a table in dependence from a check box? So if you list it in a specific subform or something like that it will be a different color? Is there another way of doing this and is there an example?
Thanks

 

[MSAccessRookie]

Hi all,
Can you change the color of lines of records in a table in dependence from a check box? So if you list it in a specific subform or something like that it will be a different color? Is there another way of doing this and is there an example?
Thanks

Based only on what I read, I am not sure what your requirements are, since I can think of at least three interpretations.

1. If you want to open a Table and have the lines displayed the way that you describe, then I am not aware of a way to do this.
2. If you want to open a Form in DataSheet View and have the lines displayed the way that you describe, then you can use either Conditional Formatting or VB Code depending on the requirements.
3. If you want to open a Report based on the Table and have the lines displayed the way that you describe, then you can use either Conditional Formatting or VB Code depending on the requirements.

Look into both options and get back to us with any questions.

-- Rookie