More than 3 conditional formats in a form?

  • Thread starter Thread starter Brent Chandler
  • Start date Start date
B

Brent Chandler

is there a way to do this without code on a single form? any help
appreciated!

brent
 
Brent said:
is there a way to do this without code on a single form? any help
appreciated!


No, there can only be three different sets of conditional
properties (in addition to the defaults).

You can have more than three sets of conditions though.
Just use a function that return True of False.

For a single form (or a report), I think it's much easier to
do it using code in the Current (or Format) events.
 
I don't see anything in the documentation limiting this to 3, but the Add
button grays out and won't let you add any more. That being the case,
changing to code is probably all you can do.
 
Back
Top