Expanded Conditional Formatting Question

[puforee]

I have a record with multiple fields. One field is a date field. I have assigned conditional formatting based on the date that, when conditions are met, the field is formatted for Red Text. I would much rather have all the fields in the record formatted as red if the date condition is met.

I assume I will have to use code instead of conditional formatting...but how can I do this.

Thanks,

 

[dhookom]

I expect you would need to do the same conditional formatting for "all the fields" that you did for the "date field". You might need to use Condition is...

Duane
Hook'D on Access
MS Access MVP

 

[puforee]

Ahhhh, yes I could do that but maybe some event code will also work (on open or something like that)....I will keep looking.

Thanks for the idea.

 

[missinglinq]

If the form is in Single View you can use code, but if it is in Continuous View or Datasheet View (as our post suggests) you can only use Conditional Formatting from the Format Menu.

You can speed up this, using []Condition Is[/b], as suggested, by selecting all of the controls, then entering the CF, rather than doing it one control at a time.


The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[puforee]

Thanks for the Ideamissinglinq. I think you just skinned my cat.

 

[missinglinq]

Glad we could help!

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!