Multi-color in List/subform/...

[Gery1984]

Hi all.

I have searched everywhere but I cannot find the anwser. I'll try to explane.

I have a table in ma database, to make it easier, let's call it Table1.

Table1:
Id,Name,Category

Now, In my form, I wanna see this table. I did it with a list, and that works perfect. Now, I want the next thing to happen:
If category = 1, then the backcolor of that record should be yellow
If category = 2, then the backcolor of that record should be green.

Now the problem is, how can I get multicoloring in my list? or in a subform?

Thx

 

[cymrudesign]

i cant tell you exactly how to do it but i would try a search for conditional formatting it might help till someone sane can get to you

 

[Cosmos75]

If you are talking about a record in a continuous form (not in datasheet view), you can use conditional formatting, but you are limited to 3 conditions and is only available for Access 2000 and higher. So if you have Access 2000 and 3 conditions is enough, great! But if you need more, you might give this a try
- 'Conditional Formating' of controls in a continuous form

 

[Cosmos75]

If you are talking about a record in a continuous form (not in datasheet view), you can use conditional formatting, but you are limited to 3 conditions and is only available for Access 2000 and higher. So if you have Access 2000 and 3 conditions is enough, great! But if you need more, you might give this a try
- 'Conditional Formating' of controls in a continuous form

 

[Gery1984]

Thx

I'll see if I can work that out.

Thx