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

Similar Threads

Conditional formatting--more than 3 conditions? 3
Recalc & conditional formatting 2
ACC2000 main form/multiple subforms...go to next record on subform 1
Bells & Whistles 19
Excel Conditioning Formatting 3
run a code based on the field conditional formatting back color 3
Conditional Formating or Continuous Form Record Formatting 1
ACC2000 Tab Order - Multiple subforms 4

Back
Top