Format text background to a particular color

[ToffaJ]

Hey Guys...

I have an instance where I'd like to change the background color of a row of field objects if one was to equal "Yes".

So if Outage equalled Yes, it would change all the fields for that record to the background color of yellow...

Thanks again for your help.... Toffa J

 

[Ngolem]

For this kind of thing I usually use a text field with a single space in it...stretched over the entire area that you want to change the color.

You can have the whole row change color but somethings this makes thing look messay because it goes magin to margin and you want to stop 1/2" short on either side.

Then in the conditional background color of the text box I would have the formula

If {Table.Outage} = "Yes" then crYellow else crNoColor;

this should work fine.

If you chnage the background of individual fields you will have a patchquilt of yellow colors across the row...this way you highlight a complete record Jim Broadbent

 

[Ngolem]

For this kind of thing I usually use a text field with a single space in it...stretched over the entire area that you want to change the color.

You can have the whole row change color but somethings this makes thing look messy because it goes magin to margin and you want to stop 1/2" short on either side.

Then in the conditional background color of the text box I would have the formula

If {Table.Outage} = "Yes" then crYellow else crNoColor;

this should work fine.

If you chnage the background of individual fields you will have a patchquilt of yellow colors across the row...this way you highlight a complete record Jim Broadbent