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!


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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top