Formatting records conditionally in a subform

[src2]

I'm using Access 2000 and I have a form called BillsOverview. On that form is a subform called Bills which is setup as a datasheet view and displays BillDescription and DaysRemaining. The other columns are hidden including a column with a color code. The valid codes are RED, YELLOW, and GREEN. I would like to change the background color of the record displayed based on the color code. From other posts I think conditional formatting is what I need to use. I set it up like this:

Condition 1 Forms!form!sfrmBills!ColorCode="RED"
Condition 2 Forms!form!sfrmBills!ColorCode="YELLOW"
Condition 3 Forms!form!sfrmBills!ColorCode="GREEN"

I changed the appropriate background and font color to what I wanted but nothing is changing. Does anyone know where I'm going wrong?

Thanks

 

[TheAceMan1]

How are ya src2 . . . . .

. . . and this:
[blue]Condition 1 [ColorCode]="RED"
Condition 2 [ColorCode]="YELLOW"
Condition 3 [ColorCode]="GREEN"[/blue]

See Ya! . . . . . .

 

[Pampers]

Hi src2,
Here is a good link for referencing:

http://www.mvps.org/access/forms/frm0031.htm

Pampers.

You're never too young to learn

 

[src2]

Thanks all, that sure was quick. I tried it and it worked (sort of). I'd really like for the whole line to change instead of just the BillDescription. I'll see if I can figure it out.

 

[PHV]

Have the whole line selected when you set the conditional format.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[TheAceMan1]

src2 . . . . .

What [blue]PHV[/blue] is saying is that you have to set [blue]Conditional Formatting[/blue] for each control in a record. [purple]Just remember textboxes & combo's only![/purple]

See Ya! . . . . . .