Set field properties based on different field in form 1

[deduct]

I have a subform where I am displaying records as a continuous form in a detail section.

I'd like to make one field a different color depending on the contents of another field in the same record.

If fld_a = "A" then I'd like fld_b to be red font color. If fld_a is any other value, I'd like fld_b to be black.

On what event and in which form section do I trap this?

Karl

 

[chew1920]

I would use Conditional Formating for those fields. I have tried in the past to use the on current and other events, but that only works for one row at a time, but changes the look of all of the rows. I just did a quick test using the conditional formatind, and that appeared to work.

HTH
Matthew

 

[Crowley16]

you can't do this using code, basically a continuous form only has 1 set of controls, therefore any change to any "row" in the form will be made on all rows...

if you want to do this, then you will have to use conditional formatting

--------------------
Procrastinate Now!

 

[deduct]

I used conditional formatting and it worked fine.

I used EXPRESSION IS [fld_b]="A", then set the color I wanted.

Thanks for pointing me in the right direction.

Karl

 

[deduct]

Just in case anybody is reading this... I actually used

[fld_a]="A"

on the "extresion is" conditional formatting of fld_b.

Karl