More than 3 conditional formats in a form?

B

Brent Chandler

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

brent
 
M

Marshall Barton

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


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.
 
W

Wayne Morgan

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.
 
Top